>$query = "select count(*) as monthly_views from visitors group by
>extract('year', time), extract('month', time) order by monthly_view desc
>Warning: Supplied argument is not a valid MySQL result resource in
>C:\Inetpub\TecEco_PHP\stats_interface\summary.php on line 75
>You have an error in your SQL syntax near ''year', time), extract('month',
>> Dig through the manual of your database (you didn't say which one) in the
>> Date/Time functions section, and see if you can find one that will extract
>> the year and month from a timestamp.
>> 1. 'extract' is probably not the right function name. You'll have to look
>> that up.
Like Music? http://l-i-e.com/artists.htm
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php