How do I make a code that will RANDOMLY pick a user from a mySQL database?
Im using my forums `users` table for the database to be randomly picked from becuase im holding a competition for when I reach 100 members, I will be giving away money. Well I want PHP to randomly pick the member when I run the script but I have no idea where to start, please help with either an Idea or a code.
Thanks!
Randomy mySQL picker
Moderator: General Moderators
- Ambush Commander
- DevNet Master
- Posts: 3698
- Joined: Mon Oct 25, 2004 9:29 pm
- Location: New Jersey, US
The MySQL documentation can do wonders...
Here's the search: http://dev.mysql.com/doc/mysql/search.p ... nd&lang=en
Related section (found from search): http://dev.mysql.com/doc/mysql/en/mathe ... tions.html
It's in there.
Here's the search: http://dev.mysql.com/doc/mysql/search.p ... nd&lang=en
Related section (found from search): http://dev.mysql.com/doc/mysql/en/mathe ... tions.html
It's in there.