<?php
$query = mysql_query("select * from forum_categorias" ,$con);
while($row = mysql_fetch_assoc($query))
{
$categoria[] = $row['categoria'];
$descricao[] = $row['descricao'];
$consult = $row[categoria];
echo 'Categorias:'.$consult.'<br>';
$a++;
$query2[$a] = mysql_query("select * from foruns where categoria = '$consult'", $con);
while($row2 = mysql_fetch_assoc($query2[$a]))
{
$titulo[] = $row2['forum']; // o Certo seria assim $titulo = $row2['forum'];
echo 'Titulo:'.$titulo.'<br>';
}
}
$smarty->assign("categoria", $categoria);
$smarty->assign("consult", $consult);
$smarty->assign("descricao", $descricao);
$smarty->assign("titulo", $titulo);
$smarty->display("index.tpl");
?>
Template
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<div class="corpo">
<div class="cabecalho">
</div>
[:section name=categorias loop=$categoria:]
<div class="forumtop">
<img src="images/forum_topl.jpg" alt=" " class="forumtopl" />
<div class="forumtoptitle">
[:$categoria[categorias]:] -
<span style="font-style:italic; font-weight:normal;">
[:$descricao[categorias]:]
</span>
</div>
<img src="images/forum_topr.jpg" alt=" " class="forumtopr" />
</div>
<div class="forumcategoriashd">
</div>
[:section name=foruns loop=$titulo:]
<div class="forumforuns">
<div class="forumfolder">
<img src="images/forum_foldersimples.jpg" alt="Simples" />
</div>
<div class="forumtitulo">
<span style="font-weight:bold;">[:$titulo[foruns]:]</span><br />
<span style="font-size:10px;">Descrição</span><br />
<span style="font-size:10px;">Liderado por: <span style="font-style:italic;">Fulando Siclano, Beltrano</span></span>
</div>
<div class="forumrespostas">
1257
</div>
<div class="forumrespostas">
1754
</div>
<div class="foruminfo">
Ultimo Post:<br />
<span style="font-weight:bold;">Fulano</span><br />
Data: 22/05/2006
</div>
</div>
[:/section:]
<div class="forum_base">
</div>
[:/section:]
<div class="rodape">
</div>
</div>
</body>
</html>
