> 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/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to