SELECT ... ORDER BY RAND() BTW there is a nice MySQL Windows mailing list.
hth Ignatius _________________________ ----- Original Message ----- From: "H Marc Bower" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 10, 2003 11:46 PM Subject: [PHP-WIN] Randomize mySQL result array This probably isn't strictly a PHP question, but I beg the indulgence of those who know mySQL as well... I have a result array grabbed from a mysql table. Is there a quick way to randomize the order that the rows fall into the array instead of "as they are extracted from the table" order? Thank you, Marc -=-=-=-=- No testimony is sufficient to establish a miracle unless the testimony be of such a kind that its falsehood would be more miraculous than the fact which it endeavours to establish. - David Hume -=-=-=-=- -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
