$dbh = SysUtils::Connect; if ($filial ne "0") { $sthg = $dbh->prepare_cached("SELECT DISTINCT login FROM usuarios WHERE filial='$filial' AND auth=4 AND login<>'$filial'"); #this one works $sthg->execute; $xg = 0; while (@rowf = $sthg->fetchrow_array()) { $gerente[$xg] = $rowf[0]; $xg++; } $sthg->finish; $cnt2= 0; foreach $gerente (@gerente) { $nome_g = ""; $meta_g = ""; $ctp = 0; if ($cnt2 == 0) { $sthn = $dbh->prepare_cached("SELECT DISTINCT nome FROM usuarios WHERE login='$gerente' AND filial='$filial'") or die "ERRO!"; #HERE'S THE STATEMENT THAT IS GENERATING THE ERROR $sthn->execute; while (@rown = $sthn->fetchrow_array()) { $nome_g = $rown[0]; $meta_g = $rown[1]; }