MDanz Posted December 24, 2010 Share Posted December 24, 2010 whne i do this i get results $construct = "SELECT * FROM Entries WHERE hec LIKE '%$search%' ORDER BY date DESC"; when i do thisi get no results $construct = "SELECT * FROM Entries WHERE (hec OR other) LIKE '%$search%' ORDER BY date DESC"; what's the problem? Quote Link to comment https://forums.phpfreaks.com/topic/222540-multiple-where-clause-not-working/ Share on other sites More sharing options...
mikosiko Posted December 24, 2010 Share Posted December 24, 2010 incorrect syntax http://dev.mysql.com/doc/refman/5.0/en/select.html and related http://dev.mysql.com/doc/refman/5.0/en/expressions.html (hec OR other) LIKE .... is not a correct expresion Quote Link to comment https://forums.phpfreaks.com/topic/222540-multiple-where-clause-not-working/#findComment-1150971 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.