Random Mysql rows inserted into PHP page

[Anon]

Hi,

I am trying to find a way to insert random data from mysql rows into different PHP files...

For example, If i have 30 rows of text in my database, I want to shuffle them randomly, and insert that data into 10 different php files, with each file containing only 3 rows of data. How could that be done?

Could someone please give me some idas?

Thank you!

[[deleted]]

You can select random rows from your MySQL database like this:

SELECT * FROM table ORDER BY rand();

If you need only 10, append LIMIT 10

Note, if you grab 30 at once, you will get 30 different ones.
If you get 3 random onces 10 times, you may get some rows twice in different files.