This is probably a silly question, but here goes... I have a table that
logs access to web services, and I am looking to create a report to
track the number of times each service was accessed in a given month.
I know I can loop through the days in the month in PHP and do a seperate
query for each day, but is there a way to do this in MySQL and populate
dates not accessed with zeros? In other words, if I have hits for the
23rd and 25th, but not the 24th, can I get something like
+--------+------------+
| Day | Hits |
+--------+------------+
| 23 | 46 |
| 24 | 0 |
| 25 | 156 |
+--------+------------+
Thanks in advance!
--
Erich Beyrent
--------------------------
http://www.beyrent.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]