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
