> according tho the description at
> <http://www.mysql.com/doc/M/a/Mathematical_functions.html>, that looks
>> $result = mysql_db_query ("$DBName","select * from Contacts order by rand()
>> LIMIT 5 ");
>> Doesn't work at all. :(
What version of MySQL are you using? I remember something about ordering by
rand() only working in 3.23.xx. If you're using 3.22.xx, it won't work.
You could do something with mysql_data_seek() and the php mt_rand() function
if that's the case. It would be klunky, but you could probably get it to
work.
Sincerely,
Paul Burney
+-------------------------+---------------------------------+
| Paul Burney | P: 310.825.8365 |
| Webmaster && Programmer | E: <[EMAIL PROTECTED]> |
| UCLA -> GSE&IS -> ETU | W: <http://www.gseis.ucla.edu/> |
+-------------------------+---------------------------------+
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]