";
}
$flag = 0;
$stmt=("SELECT
1 AS TIPO,
USRD_MEN_ID AS MEN_ID,
MEN_CAPTION,
MEN_SUB_ID,
MEN_ORDEM
FROM USUARIO_D,
MENU
WHERE
MEN_ID = USRD_MEN_ID
AND USRD_USR_ID = '$cod'
UNION
SELECT
0 AS TIPO,
MEN_ID,
MEN_CAPTION,
MEN_SUB_ID,
MEN_ORDEM
FROM MENU
WHERE
MEN_ID not in(SELECT
USRD_MEN_ID
FROM
USUARIO_D
WHERE
USRD_USR_ID = '$cod')
ORDER BY
5,4,3
");
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object ($sth))
{
$flag++;
echo "
";
$flag = 0;
$stmt=("SELECT
1 AS TIPO,
USRE_EMP_ID AS EMP_ID,
EMP_NOME,
EMP_CIDADE
FROM USUARIO_E,
EMPRESA
WHERE
EMP_ID = USRE_EMP_ID
AND USRE_USR_ID = '$cod'
UNION
SELECT
0 AS TIPO,
EMP_ID,
EMP_NOME,
EMP_CIDADE
FROM EMPRESA
WHERE
EMP_ID not in(SELECT
USRE_EMP_ID
FROM
USUARIO_E
WHERE
USRE_USR_ID = '$cod')
ORDER BY 2
");
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object ($sth))
{
$flag++;
echo "
