Jump to content

array_rand help.


brooksh

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.