Re: [PHP] Search problem

2005-05-23 Thread Kristen G. Thorson
Jim Moseby 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, wei

RE: [PHP] Search problem

2005-05-23 Thread Jim Moseby
> 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

Re: [PHP] Search problem

2005-05-22 Thread Joe Wollard
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`,`

Re: [PHP] Search problem

2005-05-21 Thread Richard Lynch
On Sat, May 21, 2005 1:35 pm, [EMAIL PROTECTED] said: > 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 fiel

Re: [PHP] Search problem

2005-05-21 Thread Rory Browne
On 5/21/05, [EMAIL PROTECTED] <[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 mor

[PHP] Search problem

2005-05-21 Thread virtualsoftware
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