Hi there, I am running mysql 3.23.49 on my server. There are some troubles with order by rand() function. It workes, but it seems, that only the first few rows are concidered. PHP pulls out 3 pics by random out of the table. I have found that this are more or less the first 50 rows. All other rows apear only verry rar. Is this a bug in mysql? Thanx, merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php