Random

[Anon]

Hi,
Does anyone know if I am able to randomize mysql records when I retrieve them? Or how I can do it in PHP? I would like to get a list of records from MySQL Database and then display them in a random order on the screen. Can anyone help? Thanks.

[cool-palace-ceo]

If you want to do something random in php you can go like this (number sample):

<?php
$number = 1<=10;
$random = rand($number);
echo($random);
?>

[Anon]

I thought of that, but how could I be sure they all got displayed, sorry I guess that wasn't clear. But they all need to be displayed and random numbers like that could take awhile.

[cool-palace-ceo]

ah, i see i am sorry. i have no idea how aboutr a for loop and the rand()?

[Anon]

Add the clause "ORDER BY rand()" to your MySQL query?

Closer to the SQL standard; extract all the results into an array, then use PHP's shuffle() function:

$query="select...";
$result=mysql_query...
$records=array();
while($record=mysql_fetch_array($result))
{ $records[]=$record;
}
shuffle($records);