Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: louissto56
- Order by date
-
Counting Sub Categories
OH sorry I forgot to mention. I wanted to count items in another table called "items". It has a column called "catID" and is equal to any given category in the category table.- louissto56
- Post #4
- Forum: MySQL
-
Counting Sub Categories
Hey. Thanks for your help. I wanted to count no matter how many levels down. Thanks.- louissto56
- Post #3
- Forum: MySQL
-
Counting Sub Categories
Hello. I have a recursion type application and need to count the category database including subcategorys. It is setup like this: catID - PK catName - varchar parentID - integer For example: Accomodation (catID = 1) is a top level category (parentID = 0). Shared Houses is a sub category of...- louissto56
- Thread
- Replies: 3
- Forum: MySQL
