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