Re: Randomize mySQL result array

SELECT ... ORDER BY RAND() BTW there is a nice MySQL Windows mailing list. hth Ignatius _________________________ ----- Original Message ----- From: "H Marc Bower" <hmbower@cogeco.ca> To: <php-windows@lists.php.net> 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 -=-=-=-=-