[SOLVED] MYSQL Or Queries

[iwpg]

This is killing me. I know it should be simple, but I cannot get the statement to run.

 

$q = mysql_query("select * from db where item1 like '%$keyword%' or item2 like '%$keyword%' or item3 like '%$keyword%'");

 

Basically, the query is checking table 1,2 and 3 for the keyword, and returns the result if found.

 

Any help will be greatly remembered and appreciated.

 

Thanks,

 

Mike

[kickstart]

Hi

 

Are you checking against several different tables?

 

If so then

 

$q = mysql_query("select * from table1 where item1 like '%$keyword%' UNION select * from table2 where item2 like '%$keyword%' UNION select * from table3 where item3 like '%$keyword%'");

 

All the best

 

Keith

[iwpg]

I'm really sorry. It's the same table, but checking in different columns.

 

Thanks, and sorry for the confusion.

[revraz]

What do you mean you can't get it to run?  Do you get an error?

[iwpg]

I get a blank result (Warning: mysql_result(): supplied argument is not a valid MySQL result resource)

[revraz]

Use mysql_error() after your querry to see if an error is returned.

 

[Maq]

Use mysql_error() after your querry to see if an error is returned.

 

 

That, and post your current relative code.

[grissom]

Hi iwpg

 

Nothing immediately strikes me as wrong but in situations like this I try throwing in a few more brackets into the expression just to make it more explicit

 

$q = mysql_query("select * from db where (item1 like '%$keyword%') or (item2 like '%$keyword%') or (item3 like '%$keyword%') ");

 

The brackets may be surplus to requirements but I'd always rather have some surplus ones than not enough.

 

[iwpg]

Thanks for the help everyone, it should have been:

$q = mysql_query("select * from db where (item1 like '%$keyword%' or item2 like '%$keyword%' or item3 like '%$keyword%')");