Shuffle Mysql_fetch

[allex01]

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'];

}

[darkfreaks]

<?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;
}?>

[Northern Flame]

what do you mean shuffle?

do you mean order them randomly?

 

if so,

try this:

 

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

[darkfreaks]

that works too

[allex01]

Thanks for both solutions.

[Northern Flame]

you're welcome

[allex01]

<?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;
}?>

 

Just a question. If i used this solution. Wouldn't this cause the result to appear more then once. How will it know the result was not already output before.

[darkfreaks]

it should not output more than once man it is correct.

 

because  $result2 equals row product name. then we shuffle the result2 which randomizes the product_name then you echo result2 which outputs your randomized answer.

[discomatt]

Use the ORDER BY RAND() solution. Much more efficient, and IMO the proper way to do it in this case.

[darkfreaks]

doesnt matter they both do the same thing one is not more proper than the other