{php}navname(message){/php}
{php}
$action = "message.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}