hno Posted November 7, 2009 Share Posted November 7, 2009 HI I want to show some information in my first page and I want to show them random and not sorted.The data come from the result of a select query. How can do so? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/180663-how-to-show-random-the-result-of-query/ Share on other sites More sharing options...
Alex Posted November 7, 2009 Share Posted November 7, 2009 Use RAND() Ex: SELECT col_name FROM table ORDER BY RAND() LIMIT 10 Quote Link to comment https://forums.phpfreaks.com/topic/180663-how-to-show-random-the-result-of-query/#findComment-953181 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.