Shuffle mysql fetch

[jim123]

I want to shuffle the array in $results. What's the simplest way to do that.

$query = "SELECT product_name FROM products" ;
$results = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($results))
{
echo = $row['product_name'];
}

[NogDog]

$query = "SELECT product_name FROM products ORDER BY RAND()";

[jim123]

Thanksssss for the solution.

[laserlight]

Remember to mark this thread as resolved using the thread tools.

Note that this really is the "simplest" way. Read the sticky in the database forum for random ordering if you want a less naive solution.

[jim123]

Someone suggested this solution. But wouldn't this make the result appear more then once.

<?php
$query = "SELECT product_name FROM products" ;
$results = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($results))
{
$results2= $row['product_name'];

shuffle($results2);
echo $results2;
}?>

[laserlight]

Someone suggested this solution. But wouldn't this make the result appear more then once.

The idea is workable, but the implementation is not correct. It should be along the lines of:

<?php
$query = "SELECT product_name FROM products" ;
$results = mysql_query($query) or die(mysql_error());
$array = array();
while ($row = mysql_fetch_assoc($results))
{
    $array[] = $row;
}

shuffle($array);

print_r($array);
?>