[SOLVED] randomly select from database?

[techiefreak05]

this might seem like a stupid question, i should be able to do this. but on the front page of my site i want a thing to show a few users. but i dont want it to show the same people over and over. i want it to select different people each time. any ideas?

 

EDIT: I already have a script that shows a few users, but it shows the same ones , i just need to know how to select different users from the database each time.

[obsidian]

Run a forum search for ORDER BY RAND() or something similar, and you'll find a bunch of discussions of the most optimal way to do what you're after. In short, you can try this (for 5 random users):

SELECT * FROM users ORDER BY RAND() LIMIT 5;

[techiefreak05]

Thanks! thats just what i wanted!