> 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
