Try this: SELECT name FROM table GROUP BY name ORDER BY RAND() LIMIT 3
This will group together all the names and then choose from a list that has only unique names and then return 3 at random. Jim Lucas ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 23, 2003 6:06 AM Subject: [PHP] Random selection > Hi, > > Can you help me with this one?? > > In my mysql db i have a colum called names; > > In names their are: > > Frank > Frank > Bob > Alice > Bob > Alice > Jim > Alice > Frank > > I want to make a random selection (max 3 value's for example).. Only it may not produce two times the same name. For example; > > This is the output: > > Frank, Jim, alice > > Wrong output > > Frank, Frank, Jim > > Please help! > > Thanks, > > Frank > > > ---------------------------------------------------------------------------- ---- > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
