Random Name

[Sharif]

I will be having a contest soon on my website where we will pick three random winners from all the members signed up at our forums. I need to make a script that will randomly pick three members from a table, and display them. Where do I start?

[DigitalExpl0it]

id ahve all the anems in a database with a uniq ID

use ID as a auto_increasment Primary field

so somthing like

ID | Name
---+-----------------------------------
1 | Joe
2 | John
3 | Zully

and so on

then id just count the database get the amount of records and then use the rand() function

$var = rand(0,$database_count);

somthing like that

[ksandom]

To extend the idea with the IDs. If you don't have sequential integer IDs, you could still use the result by doing a select statement and counting through the results until you get to the result position that corresponds to the random number generated.

[doobster]

why not just use

select * from user order by rand() limit 3

that will do it for you

[ksandom]

NICE!
I just gave that ago myself, that looks like a really good way of doing it.