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] Link to comment https://forums.phpfreaks.com/topic/25276-array_rand-help/ 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. Link to comment https://forums.phpfreaks.com/topic/25276-array_rand-help/#findComment-115311 Share on other sites More sharing options...
brooksh Posted October 27, 2006 Author Share Posted October 27, 2006 Thanks, works great. Link to comment https://forums.phpfreaks.com/topic/25276-array_rand-help/#findComment-115370 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.