[RESOLVED] How would you do this code?

[joey3002]

I am trying to get a total for each of the last 7 days.

$sql = "SELECT COUNT(*) FROM `followup` WHERE quotenumber!='' AND type='sla' AND `addeddate` = CURDATE() - INTERVAL 7 DAY";
$result = mysql_query($sql);
$7daynumber = mysql_fetch_row($result);

this does not work and I am stumped.. Is there a way to do this with 1 query?

I basically want to do an echo"$7daynumber - $6daynumber - $5daynumber" etc..

thanks

[devinemke]

SELECT DATE(addeddate), COUNT(*) FROM followup WHERE quotenumber != '' AND type = 'sla' AND addeddate BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE() GROUP BY YEAR(addeddate), MONTH(addeddate), DAYOFMONTH(addeddate)

[joey3002]

so how would I use that?

$sql = "SELECT DATE(addeddate), COUNT(*) FROM followup WHERE quotenumber != '' AND type = 'sla' AND addeddate BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE() GROUP BY YEAR(addeddate), MONTH(addeddate), DAYOFMONTH(addeddate)";
$result = mysql_query($sql);
$7daysla = mysql_fetch_row($result);

[devinemke]

$sql = "SELECT DATE(addeddate) AS date, COUNT(*) AS count FROM followup WHERE quotenumber != '' AND type = 'sla' AND addeddate BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE() GROUP BY YEAR(addeddate), MONTH(addeddate), DAYOFMONTH(addeddate)";
$result = mysql_query($sql) or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo 'date: ' . $row['date'] . ' count: ' . $row['count'] . '<br>';
}

[joey3002]

thank you so much!