[RESOLVED] Searching Across Multiple Fields

[hdsprint]

I'm stumped on a problem that maybe you can help me with.

I am trying to search across multiple fields in my database, but can only get it to search in one field only.

I have a text input box that if I put text in that matches the one field I have selected in the code, it works fine. I can change the code to a different field and have it work there, but I can't seem to figure out how to get it to search across the fields. I could probably get around this by having different input boxes to search different fields, but I'd like to just have one input box. Here is the code I believe I need to change:

$query = "select * from my_table where manufacturer like \"%$trimmed%\" 

  order by 'model'";

Also, it doesn't seem to be sorting on the "Model" as I thought it should.

The fields I want to include in the search are:

manufacturer
model
cal
mdate

Any help would be appreciated.

[NogDog]

Assuming this is MySQL, the quoting for table/column identifiers is with the "back-tick" (of left-quote), not a straight quote. For multiple fields, just use an "OR":

$query = "
SELECT * 
FROM my_table 
WHERE 
   manufacturer LIKE '%$trimmed%' OR
   another_field LIKE '%$trimmed%'
ORDER BY `model`
";

[hdsprint]

That worked SLICK! Thanks!