Jump to content

Archived

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

brooksh

array_rand help.

Recommended Posts

Here is what I need. I want to pull 10 ids from the database based on their rank. Then pick a random id out of the 10 ids. Right now it pulls 10 ids, but I want it to just pull 1 that is random.  Here is what I have.

[code]$result=mysql_query("SELECT * FROM contacts WHERE callback ='' AND updated ='' AND processing='' AND noanswer='' AND voting='' ORDER BY rank DESC LIMIT 10");
if ($myrow = mysql_fetch_array($result)) {
do
{
?>

<table width=500 align=center><tr><td><? $id = $myrow["id"]; ?>
<body onLoad="document.forms[0].submit()">
  <form method="post" name="radio_form" action="<?php echo $SCRIPT_NAME; ?>?id=<?php echo $id; ?>&processing=1&post=">
<input type="hidden" name="id" value="<?php echo $id; ?>">
<input type="hidden" name="processing" value="1">
</td></tr></table>

<?php


}
while ($myrow = mysql_fetch_array($result));
}[/code]

Share this post


Link to post
Share on other sites
[code]<?php

$query = "SELECT id FROM `Table_Name` ORDER BY rank ASC LIMIT 10";
$result = mysql_query($query);
$array=array();

while($row = mysql_fetch_array($result))
  $array[] = $row['id'];

shuffle($array);

echo $array[0];

?>[/code]

Orio.

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.