{php}
$id = $_GET[cid];
if($GLOBALS['lang'] == 'zh'){
$sql = "SELECT pid FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND id = '".$id."' ";
}elseif($GLOBALS['lang'] == 'tw'){
$sql = "SELECT pid FROM ".$GLOBALS['eces']->table('firms_nav_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND id = '".$id."' ";
}else{
$sql = "SELECT pid FROM ".$GLOBALS['eces']->table('firms_nav_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND id = '".$id."' ";
}
$aid = $GLOBALS['dbes']->getOne($sql);
if($aid != '0'){
if($GLOBALS['lang'] == 'zh'){
$sql2 = "SELECT id , name FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID='".$GLOBALS['FrimID']."' and pid='".$aid."' and soder!='0' ORDER BY `soder` ASC ";
}elseif($GLOBALS['lang'] == 'tw'){
$sql2 = "SELECT id , name FROM ".$GLOBALS['eces']->table('firms_nav_tw')." WHERE FirmID='".$GLOBALS['FrimID']."' and pid='".$aid."' and soder!='0' ORDER BY `soder` ASC ";
}else{
$sql2 = "SELECT id , name FROM ".$GLOBALS['eces']->table('firms_nav_en')." WHERE FirmID='".$GLOBALS['FrimID']."' and pid='".$aid."' 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]";
unset($hover);
}
}
if($GLOBALS['lang'] == 'zh'){
$sql3 = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid = '".$id."' and soder!='0' ORDER BY `soder` ASC ";
}elseif($GLOBALS['lang'] == 'tw'){
$sql3 = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid = '".$id."' and soder!='0' ORDER BY `soder` ASC ";
}else{
$sql3 = "SELECT * FROM ".$GLOBALS['eces']->table('firms_nav_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND pid = '".$id."' and soder!='0' ORDER BY `soder` ASC ";
}
$TS2 = $GLOBALS['dbes']->getAll($sql3);
foreach($TS2 as $k){
if($k[id] == $id ){ $hover = ' class="hover" '; }
$list2 .= "$k[name]";
unset($hover);
}
$list .= $list2;
echo $list;
{/php}