In my database, I have a single table that stores all of the individual items for sale on my website. I have 20 or so different item categories and 6 different individual items for each category. What I would like to do is find a way to have my frontpage randomly select an item from each category to display on the front page. I was wondering if anyone knows of a way to do that. Any help would be greatly appreciated. Thanks!
Scott Wolf http://www.eatshirt.com ------------------------------------------------------- WARNING! Some of the shirts on eatshirt.com are highly offensive. This is your official warning. Sure, you could say that you didn't see it, but I can prove that I sent it and that's all that matters legally. You now have no right to complain about the site content. :P ------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
