[RESOLVED] date does not match in mysql

[phpjaco]

hello

ok i got the following query but it does not seem to work:

 

$sql = "SELECT title,dt,ref,msg FROM devotional WHERE DATE_FORMAT(dt,'%d-%m') = ".date('d-m');

no error, but no result

or have also tried:

$sql = "SELECT title,DATE_FORMAT(dt,'%d-%m) as new_date,ref,msg FROM devotional WHERE new_date= ".date('d-m');

can not use variable new_date - unknown column

[phpjaco]

obviously i needed to put the date in quotes cause its a tring not an integer, ok well date.

but getting multiple results now only want the day that matches with the day / month

  $sql = "SELECT title,dt,ref,msg FROM devotional WHERE DATE_FORMAT(dt,'%d-%d') = '".date('d-m'). "'";

shouldnt this match only the day and month 12-12? why do i get multiple results.

[NogDog]

Probably because you have '%d-%d' for your date_format() format string when you meant '%d-%m'?

[phpjaco]

DATE_FORMAT(dt,'%d-%d')
should
DATE_FORMAT(dt,'%d-%m') obviously be ..

sorry. late night, lots of typos....

yeah this whole post has been an internal dailogue.