Well, for one thing, EXTRACT() is for MySQL timestamps, not unix timestamps. ---John Holmes... > -----Original Message----- > From: Noodle Snacks [mailto:webmaster@tececo.com] > Sent: Saturday, October 19, 2002 7:36 AM > To: php-db@lists.php.net > Subject: It counts everything not a specific day.. > > Although my query returns the date of the day that had the highest number > of > records inserted. > > It outputs the total number of records in the table.. > > Can someone with more experience in SQL help me only count the number of > records inserted on the day with the highest number of records? > > BTW the column time is a UNIX timestamp that is set upon insert. > > here is my query: > > $query = " > SELECT > extract(year FROM time), > extract(month FROM time), > > count(*) as monthly_views, > time > FROM > tececo_stats > group by > extract(year FROM time), > extract(month FROM time) > order by > monthly_views desc > limit 1 > "; > > > -- > JJ Harrison > lizner2002@yahoo.com.au > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
