K3dB3hdB

1DROP TABLE IF EXISTS `convenio`;
2CREATE TABLE `convenio` (
3  `codigo`      int(8)        DEFAULT NULL,
4  `cpf`         varchar(11)   NOT NULL DEFAULT '0',
5  `Nome`        varchar(35)   DEFAULT NULL,
6  `valor`       decimal(10,2) DEFAULT NULL,
7  `valorfinanc` decimal(10,2) DEFAULT NULL,
8  `dif`         decimal(10,2) DEFAULT NULL,
9  `codger`      varchar(6)    DEFAULT NULL,
10  `cpf0`        varchar(11)   DEFAULT NULL,
11  `data`        timestamp     NULL DEFAULT CURRENT_TIMESTAMP,
12  `status`                    int(11) DEFAULT '0',
13  PRIMARY KEY (`cpf`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15	
16UPDATE SET dif = valor - valorfinanc WHERE cpf = cpf
17	
18$listaconv  = mysql_query ("SELECT 
19                                  * 
20                                    FROM financeiro 
21                                      ORDER BY nome",$convenio_conn) 
22                                          or die (mysql_error());
23                                             while($row = mysql_fetch_array($listaconv)){
24                                               $VarConvCodigo         = $row[0];
25                                               $VarConvCPF            = $row[1];
26                                               $VarConvNome           = $row[2];
27                                               $VarConvValor          = $row[3];
28                                               $VarConvCodTotvs       = $row[4];
29                                               $VarConvCPF0           = $row[5];
30                                               $VarConvData           = $row[6];
31                                               $VarConvValorFinanc    = $row[7];
32                                               $VarConvDifAvancFinanc = $row[8];
33                                               $VarConvStatus         = $row[9];
34
35    $gera_divergencia = mysql_query ("UPDATE convenio 
36                                        SET difavancfinanc = '$VarConvValor'-'$VarConvValorFinanc' WHERE cpf = '$VarConvCPF'",$convenio_conn)
37                                           or die (mysql_error());
38}