Hjælp til at joine tabeller

Kode 

$sql = 'SELECT *, COUNT(pk_products) AS products FROM categories
LEFT JOIN products ON pk_categories = fk_categories
GROUP BY pk_categories';

SQL kode 

 SELECT K.fldID, K.fldNavn, COUNT(P.fldID)
 FROM tblprodukter AS P
     INNER JOIN tblkategorier AS K
         ON P.fldKatID = K.fldID
 GROUP BY P.fldKatID;

Kode 

$sql = "SELECT K.cat_id, K.cat_name, COUNT(P.cat_id) FROM ads AS P INNER JOIN categories AS K ON P.cat_id = K.cat_id GROUP BY P.cat_id;";

$result = mysql_query($sql);

$categories = array(); 
while ($rows = mysql_fetch_array ($result, MYSQL_ASSOC)) array_push ($categories, $rows); 
$smarty->assign ("category", $categories);

Kode 

{section name=category_name loop=$category}
	{strip}
		<div class="categories clearfix">
			<a href="?page_id=ad_overview&cat_id={$category[category_name].cat_id}">{$category[category_name].cat_name}<span> {$category[category_name].COUNT} annoncer</span></a>
		</div>
	{/strip}
	{/section}