array

[carisi_2000]

I would like to take the values from the id field and put them into array, and then randomly select from the array. I am using it to randomly select a photo gallery from the list of galleries.

$result=("select * from table");
while ($myrow = mysql_fetch_array($result))
{
$array=array($myrow["id"]);
$b = array_rand($array);
$newarray = $array[$b];
}

I have had no problem getting the random selector to work if I manually put in the numbers in "$array=array($myrow["id"]);" but I can't get the numbers into the array from the database. Any help would be great.

[mmilano]

forget about arrays and just use the random function built into mysql:

<?
$result=("select * from table order by rand() limit 1"); 

$id=mysql_result($result,0,"id");

echo $id;
?>

however if there is some reason you must use arrays.. do this. keep in mind there is a random function to pick a random key in an array , . but i find that it is not as random as it should be. i'd use this method instead.

<?
$result=("select * from table order by rand() limit 1");

while ($myrow = mysql_fetch_array($result)) 
{ 
  $array[]=array($myrow["id"]);
} 

// get the size of the array
$count=count($array);

// set random number
$rand=rand(0,$count);

// print the random id
echo $array[$rand];
?>

hope this helps.. have fun =)

[carisi_2000]

I am using the following code, but I do not get a random new number each time, it returns the same row every time. Am I not using this correctly.

$result=mysql_query("SELECT * FROM gallery WHERE publish='yes' ORDER BY rand() LIMIT 1");
$numres = mysql_num_rows($result);
$i=0;
while ($numres > $i){

$obj = mysql_fetch_object($result);
$gid = $obj->gid;

echo $gid;
$i++;
}