|
I haven't used plain ASP (only ASP.NET, and that was some time ago), but you can do this by querying your database, and spitting out the results. You'll probably need to mix some code directives in with the HTML associated with the ASP to accomplish this (again, not sure how it works in plain ASP).
If you have a set number of categories, and want to allow the user to select from these and only these, you can programatically add them using a repeater (if you just want a side-bar menu or something) or a drop-down list, where you add each category in code. To obtain the categories, you can use SQL's 'SELECT DISTINCT', and specify the column you want distinct values from (ie, the one that holds the 'category' field). This will make it so your menus, drop-down boxes, etc all remain in sync with your database, and only offer options to the user that are valid at any given point in time.
__________________
A man's knowledge is like an expanding sphere, the surface corresponding to the boundary between the known and the unknown. As the sphere grows, so does its surface; the more a man learns, the more he realizes how much he does not know. Hence, the most ignorant man thinks he knows it all. - L. Sprague de Camp
|