"Vern" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I found this code below that allows me to retreive the queries served on my > server for each day but can't figure out how to actually display the > information using echo. Can some one give me an example using the following > SQL? > > SELECT DATE_FORMAT(ex_date, '%Y %m %d %W'), COUNT(id) > FROM email > WHERE ex_date>Now()-INTERVAL 50 DAY > GROUP BY DATE_FORMAT(ex_date, '%Y %m %d %W') > ORDER BY DATE_FORMAT(ex_date, '%Y %m %d %W') DESC > > Thanks
i'd use : SELECT DATE_FORMAT(ex_date, '%Y %m %d %W') as mydate, COUNT(id) AS mysum FROM email WHERE ex_date>Now()-INTERVAL 50 DAY GROUP BY mydate ORDER BY mydate DESC then you get mydate as the date you need and mysum as the count of id's regards, U. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
