twilightnights Posted February 14, 2007 Share Posted February 14, 2007 $query54 ="SELECT * FROM `$table` WHERE jokebody LIKE '$subbody' AND WHERE answer LIKE '$subanswer' ORDER BY jokeID ASC"; Having trouble searching for this, is this the correct syntax? Quote Link to comment https://forums.phpfreaks.com/topic/38426-running-multiple-conditions-in-1-query/ Share on other sites More sharing options...
twilightnights Posted February 14, 2007 Author Share Posted February 14, 2007 ahh I see I should have left out the 2nd where Quote Link to comment https://forums.phpfreaks.com/topic/38426-running-multiple-conditions-in-1-query/#findComment-184347 Share on other sites More sharing options...
fenway Posted February 14, 2007 Share Posted February 14, 2007 True... and I don't see any wildcards to be used with LIKE, unless they're in the $strings. Quote Link to comment https://forums.phpfreaks.com/topic/38426-running-multiple-conditions-in-1-query/#findComment-184641 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.