Here is my SQL(used in a PHP script so this isn't ot)
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
the problem is that is counts the number of rows in the whole thing not the
echoed row. How can I get it count the best days only?
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
