RE: [PHP-DB] It counts everything not a specific day..
| From: | John W. Holmes | Date: | Sat, 19 Oct 2002 14:21:43 +0000 |
| Subject: | RE: [PHP-DB] It counts everything not a specific day.. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22520@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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