redarrow Posted September 9, 2006 Share Posted September 9, 2006 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. Quote Link to comment Share on other sites More sharing options...
Barand Posted September 9, 2006 Share Posted September 9, 2006 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] Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 9, 2006 Author Share Posted September 9, 2006 thank you cheers. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.