title: Counting number of articles within a category using CakePHP?
body: <p>I have a simple <code>cakephp</code> app with table <code>articles</code> that has a <code>cat_id</code> column to reference a <code>id</code> column of categories in a <code>cats</code> table.</p>
  
  <p>What I would like to do is display all categories names, each followed with a count of the number of articles belonging to that category.</p>
  
  <p>I know there is a <code>find('count')</code> function in <code>cakephp</code>, but that only working on one table/field. How do I link the two tables to get a list of category names and count of articles for each category for my view?</p>
  
  <p>Thanks</p>