hwoarang69 Newbie Poster 606 posts since Feb 2012 Reputation Points: 11 [?] Q&As Helped to Solve: 0 [?] Skill Endorsements: 11 [?] •Community Member 0 2 Years Ago i have this query: $item_query = mysql_query("SELECT * FROM item"); this will always get the data from 1st row to bottom row. how can i get random data? SELECT * FROM item ORDER BY RAND() or SELECT * FROM item ORDER BY NEWID() i want the best way to get random data.