function randomPairs($id) { $count = memberCount($id); $count = round($count / 2); while ($count) { $player1_id = mysql_result(mysql_query("SELECT id FROM teams WHERE opponent='0' and tourney_id='$id' ORDER BY RAND()"),0); $player1_name = mysql_result(mysql_query("SELECT name FROM teams WHERE id='$player1_id' and tourney_id='$id'"),0); $player2_id = @mysql_result(mysql_query("SELECT id FROM teams WHERE opponent='0' AND id != '$player1_id' and tourney_id='$id' ORDER BY RAND()"),0); if ($player2_id != 0) { $player2_name = mysql_result(mysql_query("SELECT name FROM teams WHERE id='$player2_id'"),0); mysql_query("UPDATE teams SET opponent='$player2_id', first='1' WHERE id='$player1_id' and tourney_id='$id'"); mysql_query("UPDATE teams SET opponent='$player1_id' WHERE id='$player2_id' and tourney_id='$id'"); } else { mysql_query("UPDATE teams SET points=points+2 WHERE id='$player1_id' and tourney_id='$id'"); } $count--; } }