Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random Record Display

Status
Not open for further replies.

LeeroyBrown1

Programmer
May 18, 2005
1
GB
I am using PHPmyAdmin and have a table with about 60 records in, i want to display these records randomly instead of an ordered list, is there an alternative to ASC DESC? RAN maybe?

Lee
 
Try:
Code:
SELECT something FROM somewhere ORDER BY RAND();
This is a MySQL question rather than PHP though.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top