hwoarang69 Posting Pro 583 posts since Feb 2012 Reputation Points: 11 [?] Q&As Helped to Solve: 0 [?] Skill Endorsements: 9 [?] 0 1 Year 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.