{php}navname(customnews){/php} {php} $action = "customnews.php"; if($GLOBALS['lang'] == 'zh'){ $sql = "SELECT id FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND action = '".$action."' and soder!='0' ORDER BY `soder` ASC "; }elseif($GLOBALS['lang'] == 'tw'){ $sql = "SELECT id FROM ".$GLOBALS['eces']->table('firms_nav_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND action = '".$action."' and soder!='0' ORDER BY `soder` ASC "; }else{ $sql = "SELECT id FROM ".$GLOBALS['eces']->table('firms_nav_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND action = '".$action."' and soder!='0' ORDER BY `soder` ASC "; } $RS = $GLOBALS['dbes']->getRow($sql); if($RS){ if($GLOBALS['lang'] == 'zh'){ $sql2 = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid = '".$RS[id]."' and soder!='0' ORDER BY `soder` ASC "; }elseif($GLOBALS['lang'] == 'tw'){ $sql2 = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid = '".$RS[id]."' and soder!='0' ORDER BY `soder` ASC "; }else{ $sql2 = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid = '".$RS[id]."' and soder!='0' ORDER BY `soder` ASC "; } $TS = $GLOBALS['dbes']->getAll($sql2); foreach($TS as $v){ if($v[id] == $id ){ $hover = ' class="hover" '; } $list .= "$v[name]"; } } echo $list; {/php}