members table
---------------------------------
ID , CREDIT , fname , lname
1 , 24 , jon , smith
2 , 50 , mark , tween
3 , 23 , sam , jonson
4 , 61 , dave , derian
5 , 28 , gio , fery
6 , 95 , anna , lopez
ads table
--------------------------------
AID , ID , ACTIVE
1 , 1 , Y
2 , 1 , Y
3 , 1 , Y
4 , 2 , Y
5 , 2 , N
6 , 2 , Y
7 , 3 , Y
8 , 3 , Y
9 , 3 , Y
10 , 4 , N
11 , 4 , Y
12 , 4 , Y
members can have few ads few rows in ads table. I want to get LIMIT 5 ads from different member randomly every time different ad. Lets say if 1 member has 3 ads get 1 ad randomly from each member LIMIT 5 times
i\'m using php4 mysql3.23
this one works but problem is it gives me a first ad in group always, it doesn\'t randomize
SELECT * FROM members m inner join ads a ON m.ID=a.ID WHERE CRED>1 GROUP BY m.ID ORDER BY RAND() LIMIT 5