On 7/24/06, Arjun Jacob Thomas Arjun.Jacob@mphasis.com wrote:

Is there any way I can retrieve the number of articles in each category somehow? So I could display it on a page somewhere?

SELECT cl_to as category, count( cl_from ) AS numberarticles FROM categorylinks GROUP BY cl_to

Greg