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 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 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.