Randomize SQL query results

/*
** The first way:
**
** Let your database server randomize the database rows for you.
** This works by adding "ORDER BY RAND()" to your query string.
** (in MSSQL you have to use "ORDER BY NEWID()")
*/
 
 
/*
** The second way:
**
** If you want to use the "ORDER BY" for another field, you 
** can randomize the resulting array by using the shuffle function:
*/
 
//  Connect to database:
$Link = mysql_connect('localhost','test_user','test_password') 
    or die('Could not connect to the server!');
 
// Select a database:
mysql_select_db('test_db') 
    or die('Could not select a database.');
 
// SQL-Query (select last 10 entries):
$SQL = "SELECT * FROM todo_list ORDER BY id DESC LIMIT 0,10";
 
// Execute the query:
$Result = mysql_query($SQL) 
    or die('A error occured: ' . mysql_error());
 
// Create empty array for the fetched rows
$Rows = array();
 
// Fetch all rows and store them in the new array:
while ($Row = mysql_fetch_assoc($Result))
    $Rows[] = $Row;
 
// Randomize all result rows
shuffle($Rows);
 
// Now do something cool with the randomized
// results:
 
foreach($Rows as $Data){
 
    // ...
 
    print $Data['Name'];
    print "<br/>\n";
 
}
 
 
 
 
// Please read the whole snippet before 
// you recommend --> ORDER BY RAND()