WHERE DATE_FORMAT count problem

[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!

[pedroz]

Sorry. Should be posted in database, may you please transfer it?

Thanks

[dagon]

few things, use count() to get the number of rows rather than selecting things you don't need

where CURDATE()=date(date)

you where trying to match a date time with a date, date() extracts just the date part

$count = mysql_query("SELECT count() FROM `table_1` WHERE CURDATE()=date(`date`)");