parent = $cat;
while($obj->parent){
$query = 'SELECT parent, id FROM '.prefix.'help_cat WHERE id = '.$obj->parent;
$res = mysql_query($query);
$obj = mysql_fetch_object($res);
} return $obj->id;
}
function get_sub_cats($cat = 0){
$query = 'SELECT * FROM '.prefix.'help_cat WHERE parent = '.$cat;
$res = mysql_query($query);
while($obj = mysql_fetch_object($res)){
?> | name?> |
| id);
}
}
$query = 'SELECT * FROM '.prefix.'help_cat ';
if(mysql_num_rows(mysql_query($query)) > 1){
$root_cat = get_root_cat($_REQUEST['cat']);
$query = 'SELECT * FROM '.prefix.'help_cat WHERE parent = 0';
$res = mysql_query($query);
while($obj = mysql_fetch_object($res)){
if(!$_REQUEST['cat']) $_REQUEST['cat'] = $obj->id;
?>
|
| name;?> |
id) get_sub_cats($obj->id); }} else $no_categories = 1; ?>
|
|
|
|
0 and cat > 0 '
: 'SELECT * FROM '.prefix.'help_main where status > 0 and cat = '.$_REQUEST['cat'].' ORDER by date desc';
$res = mysql_query($query);
while($obj = mysql_fetch_object($res)){
echo 'id.'>'.$obj->question.'
';
}?> | |
'.$obj->question.'
'.$obj->answer.' | | ';
} */?> |
|
