"; echo "
"; echo " "; $flg = 0; $dbh = ibase_connect("$p_dir", "$p_login", "$p_senha"); $stmt=(" SELECT MEN_ID ,MEN_SUB_ID ,MEN_CAPTION ,MEN_COMP ,MEN_LINK ,MEN_ORDEM FROM MENU ,USUARIO_D WHERE USRD_USR_ID = '$v_usr_id' AND USRD_MEN_ID = MEN_ID AND MEN_FLAG = 0 AND MEN_ORDEM <> 6 ORDER BY MEN_ORDEM ,MEN_SUB_ID, MEN_id "); $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object ($sth)) { if ($row->MEN_SUB_ID == 0) { if ($flg == 0) { echo "
$row->MEN_CAPTION
"; $flg = 1; } else { echo "
$row->MEN_CAPTION
"; } } else { echo "
$row->MEN_CAPTION
"; } } echo "
"; //VERIFICAR OCORRÊNCIAS $dbh = ibase_connect("$p_dir", "$p_login", "$p_senha"); ?>