cljones81 Posted March 19, 2008 Share Posted March 19, 2008 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 Quote Link to comment Share on other sites More sharing options...
AdRock Posted March 19, 2008 Share Posted March 19, 2008 ("SELECT * FROM photo WHERE id LIKE '%".$searchid."%' OR description LIKE '%".$searchid."%' OR category LIKE '%".$searchid."%' ORDER BY id") give that a try Quote Link to comment Share on other sites More sharing options...
cljones81 Posted March 20, 2008 Author Share Posted March 20, 2008 That solved it, thank you, you dont know how much of a relief it is to get that sorted Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.