I'm everyone has been to Yahoo.com -- You know there section of the main where they list the main categories and subcategories.
Does anyone have any snippets laying around that they may want to donate to me to help write this section of the page.
I have three tables, catlookup, category, and subcategory.
the catlookup has ID #'s that correspond to special id #'s that are in category and subcategory.
I've tried a few different joins, but nothing seems to do the trick.
I posted this same question in the general help forum and one guy offered some help but I could not get his solution to work (perhaps because I changed my system so its not his fault)
Rob