Hi all, I have to develop a database for a athletic sportsware company and im looking at the most effeciant way of doing this for speed in querys. the way the categorys are set up is as below Category[MLB] -Subcat [atlanta braves] -SubSubCat [T-shirt] - Product[tshirt 'a'] - Product[tshirt 'b'] -SubSubCat [Hats] - Product[hat'23'] -SubCat [Florida Marlins] -subsubcat [t-shirts] -product[tshirt 'c']Category[NBA] - subcat [chicago bulls] - etc,etc.........
On the page that list products i would like to do something like this. MLB | Atlanta Braves | tshirts(link) hats(link) etc...logo| | Random Altanta braves product or special -------------------------------------------------------------- | Florida Marlins| tshirts(links) hats(link) | | random fl marlins product or special. -------------------------------------------------------------- | next team | blah bhal bhaksdf;a lsd
On top of that i would like to limit how many items are shownon a page and have paging. I will be doing this in asp.net. The problem im having is the database dasign and query for something like this. Can anyone out there help?Edited by - johnhamman on 06/29/2002 18:28:48
Category, SubCategory, SubSubCat, & Product
Posted - 2002-06-29 : 18:28:06
