[SOLVED] i have a mysql query but cant get it to work

[marksie1988]

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)';

[marksie1988]

managed to fix it

 

$now = date('d-m');

$sql = "SELECT * FROM `logo` WHERE `date` ='$now';";