Searching multiple field of one table

[Peggy]

I'm trying to search more than one field of only one table of a data base.

I've tried a lot of different variations but none of them seem to work. The first code below will work for searching only one field.

 

$query = "SELECT * from products WHERE fulldescr like \"%$trimmed%\"  order by product ASC";

 

--------------------------------------------------------------------------------------------------------------

Here are some of the variations that didn't work for searching multiple fields

 

$query = "SELECT fulldescr, product, descr, keywords FROM products WHERE fulldescr LIKE '\"%$trimmed%\"' OR product LIKE '\"%$trimmed%\"' OR descr LIKE '\"%$trimmed%\"' OR keywords LIKE '\"%$trimmed%\"' order by product ASC";

 

$query = "SELECT fulldescr, product, descr, keywords FROM products MATCH (fulldescr, product, descr, keywords) AGAINST (\"%$trimmed%\")";

 

//----------------------------------------------------------------------

I Really appreciate any help!!

 

 

[schilly]

It looks like your search query is double quoted: '\"$trimmed\"'

 

Try

$query = "SELECT fulldescr, product, descr, keywords FROM products WHERE fulldescr LIKE '%$trimmed%' OR product LIKE '%$trimmed%' OR descr LIKE '%$trimmed%' OR keywords LIKE '%$trimmed%' order by product ASC";

 

Also make sure you output the mysql error which should help you as well.

[Peggy]

:)

Thank You!!!!

I knew it had to be a simple answer. I just hadn't figured it out.

This is actually the code I ended up using.

 

$query = "SELECT * from products WHERE fulldescr like \"%$trimmed%\" OR product like \"%$trimmed%\" OR descr like \"%$trimmed%\" OR keywords like \"%$trimmed%\" order by product ASC";

 

Thanks Again!!!!

[pbucc]

so did this work for you?  i am working something similar.