$result = mysql_query("SELECT * FROM players WHERE tourney_id='$id' ORDER BY RAND()"); while ($row = mysql_fetch_array($result)) { $players[] = $row['id']; } $count = count($players); if (!iseven($count)) { $count -= 1; $last = $players[end(array_keys($players))]; } $players1 = array(); $players2 = array(); for ($i=0;$i<$count;$i++) { if (iseven($i)) $players1[] = $players[$i]; else $players2[] = $players[$i]; }