Bad Credit Personal Loans - Property in Malaysia - Free Animated Greetings - Kamala Harris - Bet365 bonus
PDA

View Full Version : Whats the code for random

Al Capone
Aug 19th 2005, 6:46 pm
ASC = Ascending
DESC = Descending

but what's random = ???
SpeedyDomainRegistration
Aug 19th 2005, 6:59 pm
ORDER by RAND()
Al Capone
Aug 19th 2005, 7:00 pm
ah ic thanks il try that :)
Al Capone
Aug 19th 2005, 7:09 pm
it worked nevermind
SpeedyDomainRegistration
Aug 19th 2005, 9:16 pm
No problem.... glad to help. If you have large number of records, RAND() will be a bit slow. You may have to do some fancy SQL querries.

________________
Pagerank Checker Tool (http://www.hifihosting.com/pagerank.php) | Cheap Domain Name Registration (http://www.speedydomainregistration.com) | Free Web Hosting (http://www.freewebhostingdomain.com) |