RE: [PHP-DB] TOPTEN select?

[John W. Holmes]

> 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

[PHP-DB] TOPTEN select?

[[EMAIL PROTECTED]]

hello,

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...
+--+-+-+

thanks for any answers..



andreas van loock



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