Miscellany

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--;
}

}