$sql = "SELECT a.*, b.\"nome\" as nome_completo, a.\"id_usuario\"
FROM PIBIC_JR.\"usuario\" a
INNER JOIN PIBIC_JR.\"comite\" b ON (a.\"id_usuario\" = b.\"id_usuario\")
WHERE \"autorizado\" = 1
ORDER BY b.\"nome\"";
$res = oracle_select($sql);
$i = 0;
$cont=1;
while($linha = $res[$i]){
$cont++;
?>
$sql = "SELECT b.\"nome\" as nome_completo, a.\"id_usuario\" , a.\"login\", b.\"id_comite\"
FROM PIBIC_JR.\"usuario\" a
INNER JOIN PIBIC_JR.\"comite\" b ON (a.\"id_usuario\" = b.\"id_usuario\")
WHERE \"autorizado\" = 0
ORDER BY b.\"nome\"";
$res = oracle_select($sql);
$i = 0;
$cont=1;
while($linha = $res[$i]){
$cont++;
?>