Random Number Help

[troinfo]

Hey all,

I was hoping someone could help me.

I have 5 numbers I'm pulling from the database, lets say:

21
34
87
45
98

How would I randomly choose one number from just these 5 numbers.

rand() requires [int min] and [int max] so I'm not really sure how I can
do this.

Any help would be great.

Thank in Advance,
Troy

[LordShryku]

Load them into an array, and use [man]array_rand[/man].

[troinfo]

Thank you very much,

One last question.

How do I get the results of $randm_id from my while loop into an array to use it with array_rand?

I have never never been very good with arrays.

<?
session_start();

$db_name ="table_name";

$connection = @mysql_connect("****","****","****") or die(mysql_error());
$db = mysql_select_db($db_name,$connection)or die(mysql_error());

$sql = "select productId from products where proIspecial ='y'";

$result = mysql_query($sql,$connection) or die(mysql_error());

$num = @mysql_num_rows($result);

if ($num < 1) {

$display = "none";

} else {

while ($row = mysql_fetch_array($result2)){

$randm_id = $row['productId'];

}

}

$rand_values = array_rand($randm_id,1);
echo $randm_id[$rand_values[0]] . "\n";

?>

 

[LordShryku]

$randm_id = array(); // declare blank array
while ($row = mysql_fetch_array($result2)){
   $randm_id[] = $row['productId']; // load into array
} 

[drawmack]

mysql has a rand function too

<?php
session_start();

$db_name ="table_name";

$connection = @mysql_connect("****","****","****") or die(mysql_error());
$db = mysql_select_db($db_name,$connection)or die(mysql_error());

$sql = "select productId from products where proIspecial ='y' ORDER BY RAND() LIMIT 0,1";

$result = mysql_query($sql,$connection) or die(mysql_error());

$num = @mysql_num_rows($result);

if ($num < 1) {
    $display = "none";
} else {
    $row = mysql_fetch_array($result2))
    print_r($row);
} //end if
?> 

[troinfo]

Thank you very much LordShryku and Drawmack !!

For those interested here is my working test code:

<?
session_start();

$db_name ="table_name";

$connection = @mysql_connect("****","****","****") or die(mysql_error());
$db = mysql_select_db($db_name,$connection)or die(mysql_error());

$sql = "select productId from products where proIspecial ='y'";

$result = @mysql_query($sql,$connection) or die(mysql_error());

$num = @mysql_num_rows($result);

// This prints out the amount of IDs found that are on special startong from 1 to what ever.
$display = "The number of product on special $num";

// Since arrays start at 0 created a value of the amount $num - 1
$numbr = $num - 1 ;

$display .= "<br>";

// This prints out the value of $numbr which is the reult of $num - 1
$display .= "The number for the array $numbr since array start at 0<p>";

if ($num < 1) {

$display .= "No products on special none";

} else {

// This sets $randm_id to an array which was the whole key to my issue
$randm_id = array();

while ($row = mysql_fetch_array($result)){

// This is to pull the IDs out to be able to display them, is not really needed for anything other then to check the the right values are being used by the array_rand()
$test_num = $row['productId'];

// This sets the results of the while loop to and array, again the above part - for $test_num - and below part - for print $test_num - can be omitted
$randm_id[] = $row['productId'];

// This prints out all of the IDs that were found to be on special.
$display .= "$test_num<br>";

                                     }

   }

$rand_keys = array_rand($randm_id,$numbr);
$display .= "<p>";
$display .= $randm_id[$rand_keys[0]];

?>

<?print "$display";?>

Thanks,
troinfo