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!