[Smarty] Generowanie kilku kategorii Opcje

[GameMaker]

Witajcie ! mam problem z wygenerowaniem kilku kategorii dla danego artykułu.

Mój kod :

[PHP] pobierz, plaintext 
 
if (! defined ( 'Movie_CMS' )) {
	header("HTTP/1.0 404 Not Found");
}
require_once('./classes/Pager.class.php');
 
 
$zz = $db->query("Select * from mpa_movies");
$licz = $db->num_rows($zz);
 
try{
	$pager = new Pager('page','http://localhost/filmy/#PAGE#.html');
	$pager->SetTotalRecords($licz);
	$pager->SetRecordsPerPage(10);
	$pager->Make(true);
	$pag = $pager->Render();
	$start = $pager->GetIndexRecordStart();
	$end = $pager->GetIndexRecordEnd();
}
catch (Exception $e) {
	echo $e->getMessage();
}
 
 
 
$zapytanie = 'Select * from mpa_movies order by data DESC limit '.$start.','.($end - $start + 1);
$q = $db->query($zapytanie);
$arr = array();
$i = 0;
while($row = $db->fetch_array($q))
{
 
$arr[] = $row['id'];
$arr[] = $row['name'];
$arr[] = $row['data'];
$arr[] = $row['views'];
$arr[] = $row['poster'];
$arr[] = $row['describe'];
$arr[] = $row['easy_url'];
$arr[] = $row['comnum'];
$arr[] = $row['autor'];
 
$c = explode(',',$row['category_id']);
$c = array_filter($c);
$categ = "";
foreach($c as $cc)
{
$categ.= cat($cc);
 
 
}
 
$arr[] = $categ;
 
 
 
 
}
print_r($arr);
$smarty->assign('row',$arr);
$smarty->assign('pager',$pag);
 
 
 
[PHP] pobierz, plaintext 

funkcja

[PHP] pobierz, plaintext 
function cat($id)
{
global $db;
 
 $r = $db->query("Select * from mpa_categories where id ='$id'");
 
        if($db->num_rows($r) > 0)
       {
        $r = $db->fetch_array($r);
 
        $category = "<a href='/category/$r[alt_name]'>$r[name]</a>,";
 
        }else{
 
            $category = "Brak kategorii !,";
        }
 
return $category;
}
 
[PHP] pobierz, plaintext 

Plik tpl

[PHP] pobierz, plaintext 
 
{foreach $row as $con}
 
<div class="content">
  <div class="content-headline">{$con.title}</div>
  <div class="content-info">Kategoria: <b>{$con.cats}</b> | Wy&#347;wietleń: <b>{$con.views}</b> | Komentarzy <strong>{$con.comnum}</strong> | Doda&#322 : {$con.autor}</div>
  <div class="content-poster"><img src="{$con.poster}" alt="2" /></div>
  <div class="content-description">{$con.describe}</div>
  <div class="content-button">
   <div class="button-download"><a href="http://localhost/film/{$con.id}-{$con.easy_url}.html">Ogl&#261daj bez limitu</a></div>
    <div class="button-watch"><a href="/link">Ogl&#261daj</a></div>
  </div>
</div>
{/foreach}
 
{include file="paginator.tpl"}
 
[PHP] pobierz, plaintext