https://www.icyphoenix.com/viewtopic.php?f=26&t=2666&p=18841#p18841
-----------------------------------
Stunt
Thu 23 Aug, 2007 00:34

FAP CUSTOMIZATION - My Improvements
-----------------------------------
I am working on some of my own modifications to FAP and if you don't mind I would like to post my questions here when I run into problems. Chances are the answers will be very simple as I am still learning. The first thing I am going to try to do is include the amount of subcategories in the description of each album category. So the main page would look something like this...

[size=14][b]First Gallery[/b][/size]
Contains 23 Sub Categories

[size=14][b]Second Gallery[/b][/size]
Contains 7 Sub Categories

I want this to be dynamic so that I never have to update it once the code is set up. So far I have added a column in the album_cat table that holds the number of subcategories inside each category for each category. This number is incremented and decremented whenever a new category is created or deleted. Now I just have no idea how to get that number from the DB and have it display where I want it to on the albumn.php index and the album_cat.php indexes.

Any help?


