mysql search syntax help

[cljones81]

Hi Everyone:

 

I am currently writing a simple search engine script and I've written this query:

 

("SELECT * FROM photo WHERE id LIKE '%'.$searchid.'%' OR description LIKE '%'.$searchid.'%' OR category LIKE '%'.$searchid.'%' ORDER BY id")

 

Which returns this error:  Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in.....

 

But it works if I remove the wildcards but as might be expected will only return exact matches which is very limited and not what is wanted, it is my understanding that the '%'.$searchid.'%' will either return results that start or and end or contain the variable searchid.

 

So after many hours of torment by computer, I am just about ready to throw, said computer out of the window  so if a kind soul could point out where this idiot is going wrong, it will very much appreciated.

 

Christian 

[AdRock]

("SELECT * FROM photo WHERE id LIKE '%".$searchid."%' OR description LIKE '%".$searchid."%' OR category LIKE '%".$searchid."%' ORDER BY id")

 

give that a try

[cljones81]

That solved it, thank you, you dont know how much of a relief it is to get that sorted