I used to search the same way until someone on this list mentioned using
a fulltext index in mysql. Doing this almost eliminated all my headaches
with searching.
Easiest way to create a fulltext index is to use phpMyAdmin. Once you've
created the fulltext index on `title`,`description`,`price`,`weight` you
can then search all columns (much faster than the other way I might add)
by using a simply SQL query such as this:
$sql = "SELECT * FROM `products` WHERE
MATCH(`title`,`description`,`price`,`weight`) AGAINST ('" .
mysql_escape_string($_GET['query']) . "')";
More on FULLTEXT can be found here:
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
Hope that helps!
-Joe W.
www.joewollard.com <http://www.joewollard.com>
[EMAIL PROTECTED] wrote:
Hi,
I need to build up a search module for a shop. If I make a basic search
(product title for example) it is ok.
$query = "SELECT product_id FROM products WHERE title LIKE '%$title%'";
But i need an advance search for more than one field (title, description,
price, weight)
The problem is that i don't know which field is filled in by the user (title,
description, price or weight)
I mean, the user can fill in all fields, or only price field, or title and
weight etc
How can i do the search?
Thanks
