I have a database that tracks letters to the editor published in my paper. The table includes a date field and a status field. Status can be either "input" or "published."
What I want to do is create a report that tells me how many letters were published on each of the last 30 days. Is there a way to construct the query so that only one pass is made at the database, or must I loop through the last 30 days counting how many records have published status and equal date? Any suggestions would be appreciated. John Hughes __________________________________________________ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com --------------------------------------------------------------------- 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