hno Posted September 24, 2011 Share Posted September 24, 2011 HI, I want to select from a table with this term "ORDER BY `videoes`.`date_make` DESC limit 30 " and random .so every time the script return 30 latest videoes and randam from them.How can I write the sql? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/247780-how-to-select-random-with-order-by/ Share on other sites More sharing options...
the182guy Posted September 24, 2011 Share Posted September 24, 2011 have you tried ORDER BY RAND() Quote Link to comment https://forums.phpfreaks.com/topic/247780-how-to-select-random-with-order-by/#findComment-1272393 Share on other sites More sharing options...
fenway Posted September 24, 2011 Share Posted September 24, 2011 have you tried --- reading the sticky? Quote Link to comment https://forums.phpfreaks.com/topic/247780-how-to-select-random-with-order-by/#findComment-1272409 Share on other sites More sharing options...
hno Posted September 25, 2011 Author Share Posted September 25, 2011 have you tried ORDER BY RAND() Of course , I want to use order by 'date' DESC and Rand() at one query but when I try that one of them does not work anymore. How can I use them both together? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/247780-how-to-select-random-with-order-by/#findComment-1272523 Share on other sites More sharing options...
fenway Posted September 25, 2011 Share Posted September 25, 2011 My comment still applies. Quote Link to comment https://forums.phpfreaks.com/topic/247780-how-to-select-random-with-order-by/#findComment-1272636 Share on other sites More sharing options...
hno Posted September 26, 2011 Author Share Posted September 26, 2011 My comment still applies. What do you mean by sticky? Quote Link to comment https://forums.phpfreaks.com/topic/247780-how-to-select-random-with-order-by/#findComment-1272794 Share on other sites More sharing options...
fenway Posted September 26, 2011 Share Posted September 26, 2011 I mean the post that appears on the first page of the MySQL Help forum -- called the MySQL stickly. Quote Link to comment https://forums.phpfreaks.com/topic/247780-how-to-select-random-with-order-by/#findComment-1272869 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.