assign("totallast",$total,true);
$last="";
$query=mysql_query("SELECT * FROM habbophp_help_articles ORDER BY id DESC");
while($row=mysql_fetch_assoc($query)) { $last[] = $row ; }
$tpl->assign("last",$last,true);
//Category
$category="";
$query=mysql_query("SELECT * FROM habbophp_help_category ORDER BY id DESC");
while($row=mysql_fetch_assoc($query)) {
$queryee=mysql_query("SELECT * FROM habbophp_help_articles WHERE cid=".$row['id']." ORDER BY title ASC");
$total=mysql_num_rows($queryee);
$category.='
';
$queryi=mysql_query("SELECT * FROM habbophp_help_articles WHERE cid=".$row['id']." ORDER BY id DESC") OR die(mysql_error());
while($rowi=mysql_fetch_array($queryi)) {
$category.='-
'.$rowi['title'].'
';
}
$category.='
';
}
$tpl->assign("category",$category,true);
/*
$sql='SELECT * FROM habbophp_help_articles art LEFT JOIN habbophp_help_category cat ON art.cid =cat.id';
$req = mysql_query($sql);
while($data = mysql_fetch_assoc($req)){
$d[] = $data ;
}
foreach($d as $s=>$k){
foreach($k as $e){
echo''.print_r($e['value']).'
';
}
}
*/
$tpl->display('help_header.tpl');
$tpl->display('help_faq.tpl');
$tpl->display('help_footer.tpl');
?>