if(!$_REQUEST['fid']){
$query="SELECT * FROM $db_faqcat WHERE faqcat='" . $_REQUEST['cid'] . "' ORDER BY seq, cat";
$result=$zadb->query($query);
while($cat=$result->fetch_assoc()){
if(!$_REQUEST['cid']){
echo "" . $cat['cat'] . "
\n";
$query="SELECT * FROM $db_faqcat WHERE faqcat='$cat[0]' ORDER BY seq, question LIMIT 0,3";
$fresult=$zadb->query($query);
while($faq=mysql_fetch_row($fresult)){
echo "$faq[3]\n";
}
}
else{
echo "$cat[3]\n";
}
}
}
else{
$query="UPDATE $db_faqcat SET views=views+1 WHERE id='" . $_REQUEST['fid'] . "'";
$zadb->query($query);
echo "Question " . nl2br(str_replace("\.\./CMS-Images", "http://img.skilpad.com/CMS-Images", $faq[3])) . " \n";
echo "Answer " . str_replace("\.\./CMS-Images", "http://img.skilpad.com/CMS-Images", $faq[4]) . " \n";
$query="SELECT * FROM $db_wiki WHERE status='Enabled' and type='faq' and typeid='{$faq[0]}' ORDER BY date DESC";
$wresult=$zadb->query($query);
while($wiki=mysql_fetch_array($wresult)){
$query="SELECT * FROM $db_members WHERE id='{$wiki['memberid']}'";
$mresult=$zadb->query($query);
$member=mysql_fetch_array($mresult);
echo " " . nl2br($wiki['wiki']) . " Contributed by {$member['name']}, {$wiki['date']} \n";
}
}
?>
|