Lucky Draw

[maskme]

How do i randomly select 5 Customers ID from the table & display as Lucky Winners for a Lucky Draw ??

Plz help !!
Thanx

[benkillin]

if their ID is a number, use this:

rand($lowest_customer_ID, $highest_customer_ID);

put it in a loop to loop 5 times, I think you can use a do loop

and then get their info from the db.

or something like that... if their ID is letters, then I dont know how to do that

[laserlight]

I think that it is possible to use a RAND() function in the query, something of an ORDER BY RAND() LIMIT 5
Still, using PHP:

1. Select all the ids, place into an array.
2. Use array_rand() to pick 5 pseudo-random elements from this array

[Mordecai]

Theoretically, if it's random, you could pick the same 5 ids at one time. If you want to get around this, you'll have to make sure that none of the ids are the same (hence laserlight saying "psuedo-random," I'm assuming) using a conditional statement in a loop.
By MySQL would be your best bet, but I don't know whether or not it has true (well, as true as it can get) random numbers. I'm assuming it will pick 5 completely different ids (in laserlight's example), however.

[maskme]

Thanx to all of you for helping me out 🙂