How do I echo the total of links in parent category and all its children?

[Angry_Coder]

The title says it 🙂

Here's my database structure:

CREATE TABLE `categories` (
  `cid` smallint(5) unsigned NOT NULL auto_increment,
  `pid` smallint(5) NOT NULL default '0',
  `name` char(50) NOT NULL default ''
  PRIMARY KEY  (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `links` (
  `lid` int(10) unsigned NOT NULL auto_increment,
  `cid` smallint(5) NOT NULL default '0',
  `name` char(50) NOT NULL default '',
  `url` char(100) NOT NULL default ''
  PRIMARY KEY  (`lid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CID = Category ID
PID = Parent ID

Thank you in advance...

[tbach2]

recursively capture all the relevant cid's from categories and then query links against that list of id's...

You've left so much unsaid... Since you have the field 'pid', I presume that you are aware of recursion. Yet you have no code that you've tried. Where are you running into problems?