Thanks to everyone who helped so quickly =) Based on what people said, I
was able to come up with a solution. The goal was to get a total number of
log entries from a given month and year. The query we came up with is:
select count(*) as Total from log where month(datestamp) = '$current_month'
AND year(datestamp) = '$current_year'"
Since we're using PHP, getting $current_month and $current_year was pretty
easy:
$current_month = date("m");
$current_year = date("Y");
Thanks again =)
-Ed
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
