Randomizing a MYSQL query

[MrOnline]

I am trying to grab some fields out of my database and shuffle them to play eachother.

 

include ("db.php");

$read_teams="SELECT teamname FROM ptg_teams";

$read_teams_result=mysql_query($read_teams);



$a = mysql_num_rows(mysql_query("SELECT * FROM ptg_teams"));

$x = 0;



while($x < $a)

{

$data=mysql_fetch_array($read_teams_result);

$rand_keys = array_rand ($data, 2);

$randteams[$x]=$data[$rand_keys[0]]."n";

$x++;

$data=mysql_fetch_array($read_teams_result);

$randteams[$x]=$data[$rand_keys[1]]."n";

$x++;

}



$i=0;

while($i < $a)

{

$rand_keys = array_rand ($randteams, $a);

print $randteams[$rand_keys[$i]];

$i++;

} 



while()

{



$rand_keys++

echo "<br>";

}

 

This is what I have but it sorts em in pairs wrong. It just double lists the names, such as:

 

Team1 Team1

Team 2 Team 2

 

when I need it to mix em up so team1 and team2 match up together.

[lemke411]

Try using this:

ORDER BY RAND()

[fenway]

You can just shuffle a list of UIDs in php and store the result back.