array randomizer

[willwill100]

[code] if ($cycling=="RANDOM TEAM!"){
srand((float) microtime() * 10000000);

$putin = "SELECT * FROM teams";
$mallow = mysql_query($putin) or die(mysql_error());
$cap = mysql_fetch_array($mallow) or die (mysql_error());

print_r($cap);

$rand_keys = array_rand($cap, 1);

echo $cap[$rand_keys[0]] . "\n";
}[/code]

i have a table `teams` with (ID, team, rating) columns. i just want a random team to be outputted but not a lot is happening, wats wrong?

[realjumper]

What about doing it like this?

[code]
// Retrieve all the data from the table
$result = mysql_query("SELECT * FROM teams ORDER BY RAND()")
or die(mysql_error());

// store the record of the table into $row
$row = mysql_fetch_array( $result );

echo "$row[team]";
[/code]

[wickning1]

Use LIMIT to send back a single row. Otherwise you waste a lot of time.

[code]// Retrieve all the data from the table
$result = mysql_query("SELECT * FROM teams ORDER BY RAND() LIMIT 1")
or die(mysql_error());

// store the record of the table into $row
$row = mysql_fetch_array( $result );

echo "$row[team]";[/code]

[realjumper]

Quite true....thanks....I forgot that important bit