Random Selection

[dirkfirst]

From a MySQL database how can I randomly selected the data I use with mysql_query($query)?

I think that creating an array and using the rand() function is my only choice. This takes a lot of resources when I'm pulling 10,000 rows. Any Ideas?

[John]

you might be able to do this with a UNION

[Jordan]

Just use the rand() function of MySQL.

SELECT * FROM tbl ORDER BY RAND() LIMIT 1;

[sfod_d223]

I don't know if I'm asking this in the right room but here it goes. Where do I put a random function If I am trying to make random links for articles on homepage show up in different areas.

[Jordan]

If you want it on your homepage put it on your homepage. Are you using the mysql random function from above?

[dirkfirst]

Originally Posted by Jordan

Just use the rand() function of MySQL.

SELECT * FROM tbl ORDER BY RAND() LIMIT 1;

Thanks, works perfect.