shuffle an array ??

hello i want to shuffle an array with many
fields in it, but it won't work, if i have an
array with 1 field in it, it works.

i retrieve information from a mysql table,
but i want to put the information
in a random sequence, so that not everytime
the same information is on top.
here's my code :

how do i display the array at random ?$result = mysql_query("select * from inventory where groep='NIEUW' order by id1 DESC LIMIT 0, 50 ");

if ($myrow = mysql_fetch_array($result)) {

echo '<TABLE class="hoofd" cellspacing="2" cellpadding="0">';
kopregel("new CD's ");
$i=0;

//echo mysql_num_rows($result);

do {
if ($i/2 == floor($i/2)) {
beginrij();
cdgegevens($myrow["soort"],$myrow["artiest"],$myrow["titel"],$myrow["price"],$myrow["specprice"],$myrow["sufprefix"]);
}
else {
cdgegevens($myrow["soort"],$myrow["artiest"],$myrow["titel"],$myrow["price"],$myrow["specprice"],$myrow["sufprefix"]);
echo '</TR></TABLE></TD></TR>';
}

$i++;
} while ($myrow = mysql_fetch_array($result));

echo "n";

} else {

echo "Sorry, no records were found!";
}

i appreciate yours help

Jan the netherlands

I'm sorry, I'm not really following your code to well. It would help if you included the user functions you are using.

However, I would make one suggestion. If you want the rows randomized do this immediately after the query:
$numrows=mysql_num_rows($result);
while($myrow[]=mysql_fetch_array($result)){}

Now, you can randomize from 0 to numrows-1 and display that record. Then unset() that part of the array (assuming $random contains the random number generated)

unset($myrow[$random]);

After each random number generation use isset() to check if that row is still there, if not generate a new random number.

Not very efficient but it'll do what you want.