|
$varfixa = 75;
$SQL="select distinct nmsit, nmsitbus, ensit, madmint007.nrseqsit from ".$owner.".mdominiot018, ".$owner.".madmint006, ".$owner.".madmint007 where madmint006.nrseqsit=madmint007.nrseqsit and mdominiot018.nrcatidi=madmint007.nrseqcat and mdominiot018.nrseqcat=".$varfixa." order by nmsit";
//print $SQL;
$rs=getInfo($SQL);
//print $rs;
$cont = 0;
while(($cont < ($nrPorPag*$nrPag)))
{
odbc_fetch_row($rs);
$cont++;
}
$cont = 0;
while(odbc_fetch_row($rs))
{
$nmsit = odbc_result($rs,"nmsit");
$ensit = odbc_result($rs,"ensit");
$nmsitbus = odbc_result($rs,"nmsitbus");
if($cont == $nrPorPag)
{
break;
}
$cont++;
?>
 |
|
} ?>
if($nrPag > 0)
{?>
 |
}?>
if((odbc_num_rows($rs)/$nrPorPag) > $nrPag+1)
{ ?>
 |
}?>
|