Message Text |
Hi,
I have a feeling that I might be barking up the wrong tree with this question:
I want to experiment on how my directory displays the data which is accessed from the MySQL DB. At the moment the categories are A, B, C and so on. My database also has the data grouped by county and also business type (as well as town). My question is; How can I display the categories as the business type or by the county. OR, idealy, set it up so that there are both options? Let me explain my perfect scenario:
I would like to have a drop down list of counties on on the index page as well as another drop down list of the business types, so that people could browse by either - but i would also like two seperate pages off the main page with counties on one and business type on another.
Is this possible to do with WSN links? If so how? Or is this something that needs to be re ordered on the database. If so, how would I get WSN to call from two CatID's?
Please see the attached screen shot of the database to see where I want to pull the data from (I hope it's sufficient).
I am not sure if i have explained this all that clearly but it's tricky when you don't know all the possibilities or limitations.
|