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 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() 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? 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 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. 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? 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. 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
Archived
This topic is now archived and is closed to further replies.