[SOLVED] Date select from mysql

[timmah1]

I'm doing a news site for somebody, and when someone clicks on a certain topic, the script grabs everything from that certain topic.

Then I have it check if there is anything posted for today's date, and then shows that information.

 

Now, if nothing has been posted for today, they want to show yesterday's stuff for that certain topic, if nothing for yesterday, then the day before that, but nothing over days, and I do not know the correct way to do that.

 

I was going to try

<?php
$todaysDate = date("Y-m-d");
$query1 = "SELECT * FROM specials WHERE sport = '$sports' AND poston = '$todaysDate'";
$w = mysql_query($query1);
$numrows = mysql_num_rows($w);
if($numrows == 0) {
$today = date("Y-m-d", strtotime('-1 day'));

}
else {
$today = $todaysDate;
}
?>

 

But I don't understand how to grab yesterday's info then.

 

I hope this makes sense.

 

Can anybody help me out?

 

Thanks in advance