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? 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 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
Archived
This topic is now archived and is closed to further replies.