>$query = "select count(*) as monthly_views from visitors group by
>extract('year', time), extract('month', time) order by monthly_view desc
>limit 1";
>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 er
Here is my code:
When I execute it I get this error:
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',
time) order by monthly_view desc limit
>I have been going fine in a Web Stats program until now.
>
>How can I figure out which day has had the most records(ie visitors)
>inserted?
>
>There is a time column which has unix timestamp of when the record was
>inserted.
>
>The best I can think of currently is:
>To use a while loop to repeate
3 matches
Mail list logo
