Shuffle DB Results without rand()

[rpupkin77]

Hey,

I have a pretty basic question. I nee dto shuffle a result set, but due to the specific order in which I need to be returned by my query I can't use the ORDER BY rand() function.

Is there a way to randomize the result set after it has been returned? I have heard (and tried) shuffle() but I can't find a way to get it to work.

[Installer]

$result = mysql_query("SELECT * FROM my_table");
while ($row = mysql_fetch_array($result)) {
    $array[] = $row;
}
shuffle($array);