marksie1988 Posted November 8, 2007 Share Posted November 8, 2007 ok i have this query what i want it to do is select all from the table logo where the date equals todays day-month e.g. 08/11/2007 would be 08/11 without the year SELECT * FROM `logo` WHERE `date` ='date_format(%d-%m)'; Quote Link to comment https://forums.phpfreaks.com/topic/76562-solved-i-have-a-mysql-query-but-cant-get-it-to-work/ Share on other sites More sharing options...
marksie1988 Posted November 8, 2007 Author Share Posted November 8, 2007 managed to fix it $now = date('d-m'); $sql = "SELECT * FROM `logo` WHERE `date` ='$now';"; Quote Link to comment https://forums.phpfreaks.com/topic/76562-solved-i-have-a-mysql-query-but-cant-get-it-to-work/#findComment-387794 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.