
November 30th, 2001, 03:25 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,578
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
could someone help me with is asp dropdown menu
Originally posted by : mark (marks@thrivemedia.com)I'm trying to creat a drop down menu which will be auto generated from a data base. the database have 2 table, one is holding the category and another is holding the content.in this drop down menu, I want to display all the different category and the number of the record under each category.The way I know how to do this is like this:go through the category table and pull out diferent category one by one,then open the content table searching for the record under each category, then use howmanyrecs=rs.recordcountget the countis there a better way to do this so I don't have to open the record set and search the content table for each category?Thank for helping.
|