Need help writing PHP if statement using a date comparison

[JBWebWorks]

Have this sql
mysql_select_db($database_connbubba, $connbubba);
$query_rs_count = "SELECT yard_sales.yardsale_date,COUNT(*) FROM yard_sales GROUP BY yard_sales.yardsale_date";
$rs_count = mysql_query($query_rs_count, $connbubba) or die(mysql_error());
$row_rs_count = mysql_fetch_assoc($rs_count);
$totalRows_rs_count = mysql_num_rows($rs_count);

have column 'yardsale_date' format ('Y-m-d')
2009-11-01 has count of 2
2009-11-02 has count of 3

<?php if ($row_rs_count['yardsale_date']==(date('Y-m-d')))	{echo $row_rs_count['COUNT(*)'];}
		else {echo '0';}?>

that statement produces correct count of 2

trying this for 2009-11-02

<?php if ($row_rs_count['yardsale_date']==(date('Y-m-d', strtotime('+1 days'))))	{echo $row_rs_count['COUNT(*)'];}
		else {echo '0';}?>

that produces a count of 0, when it should be a count of 3. Can i use the strtotime in this way?

thanks for your help

[sfullman]

first off, start aliasing your functions in MySQL, that's a nasty thing to put in array brackets up there.

"SELECT date_field, COUNT(*) AS DayCount FROM ..."

next, you say based on your data that you have two rows one for 11-1 and one for 11-2 - but your coding only fetches one of the rows. Are you looping through b/c your code doesn't look like it.

next. do a basic troubleshoot, just before your if logic write out

echo '<pre>';
print_r(.$row_rs_count);
print_r(date('Y-m-d', strtotime('+1 days')).'<br>');
echo '</pre>';

It should be obvious at that point