Jump to content


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


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)) {

<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">


while ($myrow = mysql_fetch_array($result));

Share this post

Link to post
Share on other sites

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

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


echo $array[0];



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.