RE: [PHP-DB] TOPTEN select?
| From: | John W. Holmes | Date: | Sat, 01 Feb 2003 22:57:45 +0000 |
| Subject: | RE: [PHP-DB] TOPTEN select? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25329@lists.php.net to get a copy of this message | ||
> i have a question about a table wich works as top-ten list.
>
> why i can select all entry from today wich the hightest score?
>
> the follow is the tablestructure
>
> +--+-----+---------+------------
> |id|count|timestamp|text.......
> +--+-----+---------+------------
Maybe...
SELECT * FROM table WHERE timestamp = CURDATE() ORDER BY count DESC
limit 10
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/