[Solved] How do I randomly select a row from a database?

Question

You can add: order by rand()
to your query or you can use a PHP loop to take the 10 data points from your db into an array then use rand(0,9) to get a random ID from your array to output.

Accepted Answer

You can add: order by rand()
to your query or you can use a PHP loop to take the 10 data points from your db into an array then use rand(0,9) to get a random ID from your array to output.