Code:
$query = mysql_query("SELECT * FROM forum_kategorije");
while($a=mysql_fetch_array($query)){
$kategorije[] = $a;
$query = mysql_query("SELECT * FROM forum_podforumi WHERE kat='$a[id]'");
while($a=mysql_fetch_array($query)){
$podforumi[] = $a;
}
}
$smarty->assign('podforumi', $podforumi);
$smarty->assign('kategorije', $kategorije);
$query = mysql_query("SELECT * FROM forum_kategorije");
while($a=mysql_fetch_array($query)){
$kategorije[] = $a;
$query = mysql_query("SELECT * FROM forum_podforumi WHERE kat='$a[id]'");
while($a=mysql_fetch_array($query)){
$podforumi[] = $a;
}
}
$smarty->assign('podforumi', $podforumi);
$smarty->assign('kategorije', $kategorije);
Code:
<table width="100%" border="0" cellspacing="2" cellpadding="3">
{foreach from=$kategorije item=sta}
<tr>
<td width="43%" height="23" bgcolor="#73B000">{$sta.naziv}</td>
</tr> {/foreach}
</table>
<table width="100%" border="0" cellspacing="2" cellpadding="3">
{foreach from=$podforumi item=sta}<tr>
<td width="5%" height="23" bgcolor="#E5E5E5">Ovdje slika </td>
<td width="43%" bgcolor="#E5E5E5">{$sta.naziv}<br />
{$sta.opis}</td>
<td width="8%" bgcolor="#E5E5E5"><div align="center">{$sta.tema}</div></td>
<td width="10%" bgcolor="#E5E5E5"><div align="center">{$sta.postova}</div></td>
<td width="34%" bgcolor="#E5E5E5"><div align="center">Trenutno nema postova. </div></td>
</tr>{/foreach}
</table>
<table width="100%" border="0" cellspacing="2" cellpadding="3">
{foreach from=$kategorije item=sta}
<tr>
<td width="43%" height="23" bgcolor="#73B000">{$sta.naziv}</td>
</tr> {/foreach}
</table>
<table width="100%" border="0" cellspacing="2" cellpadding="3">
{foreach from=$podforumi item=sta}<tr>
<td width="5%" height="23" bgcolor="#E5E5E5">Ovdje slika </td>
<td width="43%" bgcolor="#E5E5E5">{$sta.naziv}<br />
{$sta.opis}</td>
<td width="8%" bgcolor="#E5E5E5"><div align="center">{$sta.tema}</div></td>
<td width="10%" bgcolor="#E5E5E5"><div align="center">{$sta.postova}</div></td>
<td width="34%" bgcolor="#E5E5E5"><div align="center">Trenutno nema postova. </div></td>
</tr>{/foreach}
</table>
Prikazuje mi samo prvu kategoriju i podforume u njoj. Ostale nista???