Alteração de Saldo Mensal das Contas
Mês :
$mes
Ano :
$ano
"; $stmt = "SELECT CTA_ID ,CTA_DESCRICAO FROM CONTA WHERE CTA_ID <> 1 ORDER BY 1"; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object ($sth)) { $valor = 0; $stmt2 = "SELECT CTSD_DTA_MOV ,CTSD_EMP_ID ,CTSD_CTA_ID ,CTSD_VALOR FROM CONTA_SALDO WHERE CTSD_EMP_ID = $cemp AND CTSD_DTA_MOV = '$data' AND CTSD_CTA_ID = $row->CTA_ID AND CTSD_CTA_ID <> 1"; $sth2 = ibase_query($dbh, $stmt2); while ($row2 = ibase_fetch_object ($sth2)) { $valor = str_replace(".",",",$row2->CTSD_VALOR); } echo "
$row->CTA_ID.$row->CTA_DESCRICAO :
"; } echo "
"; ?>
