MySQL

[Nickosssss]

Hello there,

I would like to ask if anybody knows how to randomize an output of a query

for example

$query = select * from student where stud_id = '$urn';

for ($i < num_results....)
{

$row = $result -> fetch_assoc();

$test = array($row['stud_id'];
shuffle($test);

for ($j = 0 ; $j < num_resutls; $j++)
{
echo $test[$j];
}

...........

it seems that the $row cannot be randomized

thanks

[Drakla]

Nope, you're just doing it wrong. You're trying to shuffle a scalar value, not an array

$query = select * from student where stud_id = '$urn';

while ($row = $result->fetch_assoc())
{
    $test[] = $row['stud_id'];
}

shuffle($test);

for ($j = 0 ; $j < count($test); $j++)
{
    echo $test[$j];
}

But according to your query you'd be limiting it to one student anyway in your WHERE clause.