GoFuckYourself.com - Adult Webmaster Forum - View Single Post

seeme · 07-22-2012, 09:34 AM

Ok I have the following tables, what I want to do is select 1 random item from ITEMS for each group in GROUPS. If possible done in 1 query.

ITEMS
ID - NAME - DESCRIPTION - GROUP

GROUPS
ID - TITLE - STATUS

Thanks

07-22-2012, 09:34 AM
seeme Stephen Industry Role: Join Date: Jun 2011 Location: Europe Posts: 840	MySql Help Ok I have the following tables, what I want to do is select 1 random item from ITEMS for each group in GROUPS. If possible done in 1 query. ITEMS ID - NAME - DESCRIPTION - GROUP GROUPS ID - TITLE - STATUS Thanks