Most Searches in a Day

[eluser]richthegeek[/eluser]
Sample code

Code:

<?php

$query = mysql_query( "SELECT timestamp FROM search" );
$searchDays = array();
while( $row = mysql_fetch_assoc( $query ) )
{
    $day = round( $row[ 'timestamp' ] / 86400 );
    $searchDays[ $day ]++;
}
asort( $searchDays );
$day = key( current( $searchDays ) ) * 86400;
$date = date( "d m y", $day );

print $date." with ".current( $searchDays )." searches";

?>