salve estraggo dei dati e li passo a smarty con array pero non capisco il perche mi da delle A
Codice PHP:
$DB->connect();
function totale($cat_id){
$result = mysql_query("select * from knowledgebase where k_cat= $cat_id and visible ='1' and enable = '1' ");
$tot=mysql_num_rows($result);
return $tot;
}
$contolo_categoria = mysql_query("select * from knowledgebase where k_cat ='$id' and enable ='1' order by id desc ");
while($array=mysql_fetch_array($contolo_categoria)){
$contr_categoria =$array['k_cat'];
}
$DB->connect();
$result_cat_know = mysql_query("select * from knowledgebase_cat where enable ='1' order by id desc ");
$risultato_categoria_know = mysql_num_rows($result_cat_know);
if($risultato_categoria_know >0){
while($array=mysql_fetch_array($result_cat_know)){
$estrazione_kat_know['id'] = $array['id'];
$estrazione_kat_know['nome'] = $array['nome'];
$smarty->assign("array_kat_know","$estrazione_kat_know");
$id = $array['id'];
$title = $array['nome'];
$result_know = mysql_query("select * from knowledgebase where k_cat ='".$array['id']."' and visible ='1' and enable ='1' order by id desc limit 3" );
$result_articl = mysql_num_rows($result_know);
if($result_articl >0){
while($array=mysql_fetch_array($result_know)){
$estrazione_knowledgebase['domanda_know'] = $array['domanda'];
$estrazione_knowledgebase['data_know'] = $array['data'];
$smarty->assign("array_domanda_know","$estrazione_knowledgebase");
}
}
else{
$smarty->assign("domanda_know","<div class='textsfondo'>"._NO_ARTICLE_KNOWLDG."</div>");
}
}
}else {
$smarty->assign("domanda_know","<div class='textsfondo'>"._NO_CATEGORY_KNOWLDG."</div>");
}
$DB->connect();
$result_cat_know = mysql_query("select * from knowledgebase where k_cat ='0' and visible ='1' and enable ='1' order by id desc ");
$result_cat = mysql_num_rows($result_cat_know);
if($result_cat >0){
while($array=mysql_fetch_array($result_cat_know)){
$estrazione_knowledgebase_article['domanda_artile_know'] = $array['domanda'];
$estrazione_knowledgebase_article['data_artile_know']= $array['data'];
$smarty->assign("array_domanda_know","$estrazione_knowledgebase_article");
questo ivece e tpl
codice:
<table id='contenutitexticone' border="0" width="100%" cellpadding="0" cellspacing="0" >
<tr>
<td>
{foreach name=nome item=row from=$array_kat_know}
<table class = 'tablecatknow' border ='0' cellpadding='0' cellspacing='0' width="100%">
<tr>
<td class ='imagecategoryknow'>[img]../immagini/icon_folderyellow.gif[/img]</td>
<td class ='categoryknow'> {$row.nome} <span class ='numerarticle'>{$count_cat_categorie_know}</span></td>
<td class ='rssiconknow'></td>
</tr>
</table>
{/foreach}
</td>
</tr>
<tr>
<td>
{foreach name=nome item=row from=$array_domanda_know}
<table class = 'ultimiarticoliknow' border ='0' cellpadding='0' cellspacing='0' onMouseOver="javascript:this.className='navitem'" onMouseOut="javascript:this.className ='navitemhover'">
<tr>
<td class ='imagearticolokn'>[img]../immagini/icon_topicyellow.gif[/img]</td>
<td class='articoloknow'>{$row.domanda_know}</td>
<td class ='dataarticoloknow'>{$row.data_know}</td>
</tr>
</table>
{/foreach}
</td>
</tr>
<tr>
<td>
<table class = 'tablecatlibertitleknow' border ='0' cellpadding='0' cellspacing='0'>
<tr>
<td class ='imagecategorylibertitleknow'>[img]../immagini/icon_articlelist.gif[/img]</td><td class ='categorylibertitleknow'>".ARTICLE."</td>
<td class='rssiconknow'><a href ='$url_sito/rss/rss.php?id=$contr_categoria'>[img]../immagini/feedicon.gif[/img]</a></td>
</tr>
</table>
{foreach name=nome item=row from=$array_domanda_know}
<table class = 'ultimiarticoliknow' border ='0' cellpadding='0' cellspacing='0' onMouseOver=\"javascript:this.className='navitem'\" onMouseOut=\"javascript:this.className ='navitemhover'\">
<tr>
<td class ='imagearticolokn'>[img]../immagini/icon_topicyellow.gif[/img]</td>
<td class='articoloknow'>{$row.domanda_artile_know}</td>
<td class ='dataarticoloknow'>{$row.data_artile_know}</td>
</tr>
</table>
{/foreach}
</td>
</tr>
</table>
perche ????????????