brooksh Posted October 27, 2006 Share Posted October 27, 2006 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] Quote Link to comment Share on other sites More sharing options...
Orio Posted October 27, 2006 Share Posted October 27, 2006 [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. Quote Link to comment Share on other sites More sharing options...
brooksh Posted October 27, 2006 Author Share Posted October 27, 2006 Thanks, works great. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.