pozdrav.
u forum.php imam:
PHP kôd:
<?php
$smarty = new Smarty;
include ("zabranjen_pristup.php");
include ("config.php");
// KATEGORIJE //
$kategorije = array();
$kat = mysql_query("SELECT * FROM kategorije ORDER by 'lista' ASC");
while($a=mysql_fetch_array($kat)){
$kategorije[] = $a;
}
$smarty->assign('kategorije', $kategorije);
// FORUMI //
// Uzimam id-eve kategorija bez arraya da ne bi bilo dole WHERE kategorija='Array' //
$kate = mysql_query("SELECT id FROM kategorije");
while($c=mysql_fetch_array($kate)){
$idkat = $c["id"];
$for = "SELECT * FROM forumi WHERE kategorija='$idkat' ORDER by 'lista' ASC";
$query = mysql_query($for);
while($b=mysql_fetch_array($query)){
$forumi[] = $b;
}
}
$smarty->assign('forumi', $forumi);
$smarty->display('forum.tpl');
u forum.tpl imam:
Kôd:
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="bgfooter">Forum menadžment</td>
</tr>
<tr>
<td height="31"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="54%" class="bgfooter">Dobrodošao u forum menadžment. </td>
<td width="27%" bgcolor="#D5ECFF"><a href="#" class="meni">Kreiraj novu kategoriju </a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25"><table width="100%" border="0" cellspacing="2" cellpadding="4">
<tr>
<td width="34%" height="25" class="bgfooter" align="center">Ime kategorije/foruma i opis </td>
<td width="17%" class="bgfooter" align="center">#</td>
<td width="17%" class="bgfooter" align="center">#</td>
<td width="12%" class="bgfooter" align="center">Gore / dole</td>
<td width="20%" class="bgfooter" align="center">Opcija</td>
{foreach from=$kategorije item=sta} </tr>
<tr>
<td class="bgfooter">{$sta.naziv}</td>
<td class="bgfooter" align="center">Edituj</td>
<td class="bgfooter" align="center">Obriši</td>
<td class="bgfooter" align="center">Gore / dole </td>
<td class="bgfooter" align="center">Dodaj moderatora </td>
{foreach from=$forumi item=sta} </tr>
<tr>
<td bgcolor="#EAEAEA">{$sta.naziv}<br>
<span style="font-size:11px;">{$sta.opis}</span></td>
<td bgcolor="#EAEAEA" align="center">Edituj</td>
<td bgcolor="#EAEAEA" align="center">Obriši</td>
<td bgcolor="#EAEAEA" align="center">Gore / dole</td>
<td bgcolor="#EAEAEA" align="center">Dodaj moderatora </td>
</tr>{/foreach} {/foreach}
</table></td>
</tr>
</table>
ispisuje mi sve forume u sve kategorije, što ne bi trebalo, u čemu je problem.