MySql Help

[seeme]

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

[Harmon]

I guess your answer lies within gun control in the US. If only there weren't so many gunzzzzzzzzzzzzzzzzzz!

Faggot. Suck a cock.

[fris]

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

i left you a few msgs, you can cancel the thing we talked about.

[kazymjir]

SELECT *
   FROM `items`
   GROUP BY `group`
   ORDER BY RAND();

Selects one random item from each group

[seeme]

SELECT *
   FROM `items`
   GROUP BY `group`
   ORDER BY RAND();

Selects one random item from each group

When I refresh the query I still get the same item from each group... just that the final list of items is ordered randomly.

[kazymjir]

When I refresh the query I still get the same item from each group... just that the final list of items is ordered randomly.

Ahhhh, true.

Try this:

SELECT * 
   FROM (SELECT * FROM `items` ORDER BY RAND()) x
   GROUP BY x.group
   ORDER BY RAND();

[ShoeBox]

I guess your answer lies within gun control in the US. If only there weren't so many gunzzzzzzzzzzzzzzzzzz!

Faggot. Suck a cock.

[seeme]

Ahhhh, true.

Try this:

SELECT * 
   FROM (SELECT * FROM `items` ORDER BY RAND()) x
   GROUP BY x.group
   ORDER BY RAND();

Thanks thats what I needed

[adultdomainseller]

I guess your answer lies within gun control in the US. If only there weren't so many gunzzzzzzzzzzzzzzzzzz!

Faggot. Suck a cock.