{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]

"; } } if($GLOBALS['lang'] == 'zh'){ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid='0' and soder!='0' order by `soder` asc "; }elseif($GLOBALS['lang'] == 'tw'){ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid='0' and soder!='0' order by `soder` asc "; }else{ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid='0' and soder!='0' order by `soder` asc "; } $RS = $GLOBALS['dbes']->getAll($sql); foreach($RS as $v){ $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' || $v[action] == 'othertw.php' || $v[action] == 'otheren.php' ){ $list_nav .= ""; }elseif($v[action] == 'productcart.php' || $v[action] == 'ordercheck.php'){ $list_nav .= ""; }elseif($v[action] == 'productshow.php'){ $list_nav .= ""; if(!empty($prods)){ $list_nav .= "

".$prods."

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

"; }else{ $list_nav .= "
".$v[name]."
"; } foreach($ts as $y ){ $list_nav .= "
• $y[name]
"; } $list_nav .= "
"; } } echo $list_nav; {/php}