This is the query i use at the moment, is it possible to have it print out all days of the particular month and have 0 for the days there are no results? instead of what it does now only the days when there are results.
mysql_query("SELECT page, COUNT(id) AS cnt, DATE_FORMAT(time_stamp,'%D') AS day FROM track_detail WHERE page='$page' AND DATE_FORMAT(time_stamp,'%c') = '$month' AND DATE_FORMAT(time_stamp,'%Y') = '$year' GROUP BY DATE_FORMAT(time_stamp,'%d') ORDER BY day ASC");
mysql_query("SELECT page, COUNT(id) AS cnt, DATE_FORMAT(time_stamp,'%D') AS day FROM track_detail WHERE page='$page' AND DATE_FORMAT(time_stamp,'%c') = '$month' AND DATE_FORMAT(time_stamp,'%Y') = '$year' GROUP BY DATE_FORMAT(time_stamp,'%d') ORDER BY day ASC");