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? Link to comment https://forums.phpfreaks.com/topic/18485-mysql-error-curdate-solved/ 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. Link to comment https://forums.phpfreaks.com/topic/18485-mysql-error-curdate-solved/#findComment-79577 Share on other sites More sharing options...
digitalgod Posted August 23, 2006 Author Share Posted August 23, 2006 ah thanks Link to comment https://forums.phpfreaks.com/topic/18485-mysql-error-curdate-solved/#findComment-79591 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.