Page 1 of 1

WHERE DATE_FORMAT count problem

Posted: Tue Nov 30, 2010 1:10 pm
by pedroz
table_1
id, date, username
786, 2010-11-15 17:26:00, 22905035
787, 2010-11-29 18:26:01, 102380017
787, 2010-11-29 18:26:08, 102380017

$count = mysql_num_rows(mysql_query("SELECT `id` FROM `table_1` WHERE DATE_FORMAT(`date`,'%d%m%Y') = '".date('dmY')."'"));

considering today is 29-Nov-2010...
echo $count // ...2
should be 2 but it is not working...

anyone knows why?

thanks!

Re: WHERE DATE_FORMAT count problem

Posted: Tue Nov 30, 2010 3:00 pm
by Christopher
Have you checked whether those date formats in PHP and SQL provide the same values. For example, do the codes provide leading zeroes or not?

You can also just do:

Code: Select all

$count = mysql_num_rows(mysql_query("SELECT `id` FROM `table_1` WHERE `date` = '".date('Y-m-d')."'"));