View Single Post

  #2 (permalink)  
Old 08-23-2003
fkeessen@planet.nl
 
Posts: n/a
Default 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


Reply With Quote