Randomly select rows from MySQL Database
Posted: Mon Jul 04, 2005 8:39 am
I have a database with 10 rows. I would like to display each row one at a time in random order. How can I select rows from a database in random order without repeting a row? Basically I would like to reorder the database for each user so that the user will see all of the rows in a different order. I understand the rand() function but I need to limit the query so that each question is only asked once.
I am new to PHP and MySQL so I am just looking to be pointed in the right direction. Maybe just suggest a function that I could use and I will do the research.
Thanks
I am new to PHP and MySQL so I am just looking to be pointed in the right direction. Maybe just suggest a function that I could use and I will do the research.
Thanks