Jump to content


This topic is now archived and is closed to further replies.


Selecting ONE random product from each category

Recommended Posts

I have a table called 'featured' that holds 3 featured products for each category, at the moment I have 6 categories, leaving me with 18 products. I want to display one featured product from each category, so I wrote the query: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM `featured` GROUP BY category ORDER BY RAND() [!--sql2--][/div][!--sql3--] Although this picks one product from each category, it also doesn't do what I expected, it picks the same product from each category every time but just displays them in a different order. The products its picking appear to be the first product in the database of that particular category.


Any ideas on how I should go about pulling a random product from each category, instead of the same products in a different order?

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.