{php} $sql3 = "SELECT cat_id,cat_name,parent_id FROM ".$GLOBALS['eces']->table('category_zh')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND parent_id = '0' ORDER BY `sort_order` ASC "; $QS = $GLOBALS['dbes']->getAll($sql3); if(!empty($QS)){ foreach($QS as $t){ $prods .= "

$t[cat_name]

"; } } $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid='0' AND soder != '0' order by `soder` asc"; $RS = $GLOBALS['dbes']->getAll($sql); foreach($RS as $v){ if( $v[id] != '4898' && $v[id] != '4897' ){ $sql2 = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid = '".$v[id]."' AND soder != '0' order by `soder` asc"; $ts = $GLOBALS['dbes']->getAll($sql2); if(empty($ts)){ if($v[action] == 'other.php'){ $list .= "

$v[name]

"; }elseif($v[action] == 'productshow.php'){ $list .= "

$v[name]"; if(!empty($prods)){ $list .= $prods; } $list .= "

"; }else{ $list .= "

$v[name]

"; } }else{ $surl = substr($v['action'],0,-4); if($v[action] == 'other.php'){ $list .= "

$v[name]

"; }else{ $list .= "

$v[name]

"; } foreach($ts as $y ){ $list .= "

$y[name]

"; } $list .= "

"; } } } echo $list; {/php}