two tables joined, need count of joins

[imstillatwork]

here is my simple two tables joined.

SELECT
 l.id AS lid
 ,l.title AS ltitle

 ,c.id AS cid
 ,c.title AS ctitle

FROM links AS l
LEFT JOIN category AS c
ON c.id = l.category_id

Without a subquery (mysql 4.0.16, hosted) how can I coun the links per category?

Thanks, I'm sure r937 will have a deliciously elegant way to make this work

 

[r937]

select c.id      as cid
     , c.title   as ctitle
     , count(l.category_id) as links
  from category as c
left outer
  join links as l
    on c.id = l.category_id 
group
    by c.id  
     , c.title

r937.com | rudy.ca

 

[imstillatwork]

simple. thanks!