[solved]mixed information shown

[redarrow]

Hi there all hopes all ok can you kindly show me how to show from a mysql database how to mix all the entrys up and show them all in mixed view .

example if you had a database called members and you wanted to show all members but all shown as mixed and jumbled up cheers.

[Barand]

This will output names in random order

[code]<?php

$sql = "SELECT membername FROM members
        ORDER BY RAND()";
$result = mtsql_query ($sql) or die (mysql_error() );
while ($row = mysql_fetch_assoc($result)) {

        echo $row['membername'] , '<br>';
}
?>[/code]

[redarrow]

thank you cheers.