Jump to content


Photo

Selecting ONE random product from each category


  • Please log in to reply
1 reply to this topic

#1 Kris

Kris
  • Staff Alumni
  • Advanced Member
  • 2,755 posts
  • LocationThe Internet

Posted 18 October 2005 - 09:50 PM

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?

#2 Kris

Kris
  • Staff Alumni
  • Advanced Member
  • 2,755 posts
  • LocationThe Internet

Posted 20 October 2005 - 09:28 PM

*Bump




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users