Jump to content

Archived

This topic is now archived and is closed to further replies.

willwill100

array randomizer

Recommended Posts

[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?

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.