Random rows

[Tim158]

Can anybody tell me why this piece of code doesn't display random names? At the moment it just displays names in reverse order:

$sql = "SELECT * FROM members WHERE sponsor='1' ORDER BY rand()";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

$num=mysql_numrows($result);

mysql_close($db);

echo"<ol>";

$i=0;
while ($i < $num) {

$xname = mysql_result($result,$i,"name");

echo "<li>$xname</li>";

++$i;
}
echo"</ol>";

Thanks,
Tim.

[Tim158]

It's ok, I fixed my own problem.

I needed to set the srand(); function before using rand()