Hi,
i wrote a small web catalog and used the table structur from phpHoo.
That means there's a table "MyLinks" with LinkID,CatID,url,title and so on .. and a table "MyCategories" with CatID,Name,CatParent.
Now I want to count the entries/sites by their _main_ CatID. In other words: i'd like to know how many sites I have with CatID x including all sites in any other sub-categorie.
Has somebody already written an SQL-Query or some kind kind of php code that does this job?
Thanking you in advance...
regards,
Marty
i wrote a small web catalog and used the table structur from phpHoo.
That means there's a table "MyLinks" with LinkID,CatID,url,title and so on .. and a table "MyCategories" with CatID,Name,CatParent.
Now I want to count the entries/sites by their _main_ CatID. In other words: i'd like to know how many sites I have with CatID x including all sites in any other sub-categorie.
Has somebody already written an SQL-Query or some kind kind of php code that does this job?
Thanking you in advance...
regards,
Marty