[PHP-DB] Random From: John Hurleston (jhurleston <email protected>)
Date: 08/31/01

I would like to get the first 5 random entries out of my "mysql" database,
what would be the correct SELECT option?

I adjusted this line

$result = mysql_db_query ("$DBName","select * from Contacts LIMIT 0,5 ");
which works correctly. :)

$result = mysql_db_query ("$DBName","select * from Contacts order by rand()
LIMIT 5 ");
Doesn't work at all. :(

Can anyone through any light on this subject.

Thanks. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>