digitalgod Posted August 23, 2006 Share Posted August 23, 2006 hey guys,I have this mysql query[code]<?phpmysql_query("SELECT * FROM events WHERE CURDATE() == date ORDER BY id") or die(mysql_error());?>[/code]and I get an error saying that it's somewhere here : == date ORDER BY idI just want it to find all the events that are dated for today. Any reason why it's giving me that error? Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted August 23, 2006 Share Posted August 23, 2006 == is php's equality operator. Use a single = in SQL. Quote Link to comment Share on other sites More sharing options...
digitalgod Posted August 23, 2006 Author Share Posted August 23, 2006 ah thanks 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.