Hi everybody. I keep getting errors when i try to create a loop in php.

PHP Code:

$date=date("d/M/Y");

$sql="SELECT * FROM files WHERE date='".$date."'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);

echo "Pictures uploaded today:"; 
echo $count; 


This is my code gives me the result "pictures uploaded today: 3"

So it works fine. But i would like to do so that is shows.

Pictures uploaded today : 3
Pictures uploaded Yesterday: 5
Pictures uploaded today -2: 3
and so on, for a whole week.


So i want this loop to count the pictures uploaded today, and 6 days back. How should that loop looks like?

PHP Code:

$time = time();
for($i = 0; $i < 7; $i++)
{
     $newTime = $time - ($i * 24 * 60 * 60);
     $date = date('d/M/Y', $newTime);

     $sql = "SELECT * FROM files WHERE date = '$date'";
     $result = mysql_query($sql);
     $count = mysql_num_rows($result);

     echo "Pictures uploaded on $date: $count <br/>"; 
} 


Thank you very much. It was your trick with adding a day to times i couldnt figure out.

It works. Thanks!!!