Most Searches in a Day

[eluser]EEssam[/eluser]
A good guy just told me how to do it in SQL:

Code:

SELECT DATE(FROM_UNIXTIME(`timestamp`)) AS the_day, COUNT(*) AS the_count FROM search GROUP BY the_day ORDER BY the_count DESC LIMIT 1