Well, lets say that I have 100 auction categories each assigned a number (100,101,102 etc). I have a main category called 100, a sub category called 101, and a third level category called 102. So user would have to click 3 times to get to 102 (like Art>Supplies>Brushes). Lets say the user was on .com/browse.php?cat=101 (or Supplies) and I wanted it to show all the next categories ie 102,103,104 etc. How would I have that in a db? Also, in cat 101 it would display below some auctions (eg closing) from 102,103,104. HOw should I code that in a db? More info. If user click on a third level cat e.g 102, then the url would be .com/browse.php?cat=102. Get what I mean? So in cat 100 we would be able to see other sub cats + other sub cats auctions. Then in next sub cat we would see those sub cat auctions + third level sub cats. Then in the third level we would only see those auctions and not and mroe cats. I know this may be hard (or easy) but please help! Thanks you very much. Sam.

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.

Sign In

[SOLVED] Here is a tricky one... db theory

Recommended Posts

forumnz

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information