ssjskipp Posted July 6, 2006 Share Posted July 6, 2006 How can I run a query that orders the data randomly?IE:Normally, throught PHP and MySQL, I'd do this:[code=php:0]<?$order = "ORDER BY `id` ASC";$query = mysql_query("SELECT * FROM `user` WHERE `active` = '1' $order");$rows = mysql_num_rows($query);if ($rows > 0){while($data = mysql_fetch_array($query)){echo $data["name"];}} else {echo "No users";}?>[/code]But how would I do that in a random order, rather than by id and ascending? Link to comment https://forums.phpfreaks.com/topic/13899-query-help-o/ Share on other sites More sharing options...
effigy Posted July 6, 2006 Share Posted July 6, 2006 ...order by rand() Link to comment https://forums.phpfreaks.com/topic/13899-query-help-o/#findComment-54147 Share on other sites More sharing options...
ssjskipp Posted July 7, 2006 Author Share Posted July 7, 2006 Thankies ^_^ Link to comment https://forums.phpfreaks.com/topic/13899-query-help-o/#findComment-54171 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.