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.