Code: Select all
<?php
mysql_connect("dbhost", "dbusername", "dbpassword");
$db = mysql_select_db("dbname");
$result = mysql_query("SELECT name FROM ruc_players");
$arr = mysql_fetch_array($result, MYSQL_NUM);
srand((float)microtime()*1000000);
shuffle($arr);
$team = 1;
while (count($arr) > 0)
{
$name = array_pop($arr);
mysql_query("UPDATE ruc_players SET team='$team' WHERE name='$name'");
$team = (($team == 7) ? 1 : $team + 1);
}
?>