Update record problem

[carlmty]

When I try to read a record in the table, and change the value from a fix number, to zero, it doesn't update in the database table.

Here is the code to explain myself more:

<?php
  include("conectar.i");
   $resu=mysql_query("select * from calint",$Conexion);
          $ro=mysql_fetch_array($resu);
          if ($ro)
             {
             $fe=$ro["fec_cint"];
             $graba=("UPDATE calint SET sdo_cint=0 where fec_cint = '$fe'");
             }
?>

And the table definition:

CREATE TABLE calint (
fec_cint date NOT NULL default '0000-00-00',
sdo_cint decimal(11,2) NOT NULL default '0.00',
tasa_cint decimal(11,2) NOT NULL default '0.00',
int_cint decimal(11,2) NOT NULL default '0.00',
UNIQUE KEY fec_cint (fec_cint)
) TYPE=MyISAM COMMENT='Tabla del Calculo de Intereses de Paso';

#

dump into calint TABLE

#

INSERT INTO calint VALUES ('2003-04-01', '25000.00', '14.35', '0.00');
INSERT INTO calint VALUES ('2003-04-02', '25000.00', '14.25', '0.00');
INSERT INTO calint VALUES ('2003-04-03', '25000.00', '14.40', '0.00');
INSERT INTO calint VALUES ('2003-04-04', '25000.00', '14.10', '0.00');
INSERT INTO calint VALUES ('2003-04-05', '25000.00', '13.90', '0.00');
INSERT INTO calint VALUES ('2003-04-06', '25000.00', '14.30', '0.00');
INSERT INTO calint VALUES ('2003-04-07', '25000.00', '14.30', '0.00');
INSERT INTO calint VALUES ('2003-04-08', '25000.00', '14.30', '0.00');
INSERT INTO calint VALUES ('2003-04-09', '25000.00', '14.50', '0.00');
INSERT INTO calint VALUES ('2003-04-10', '25000.00', '13.95', '0.00');
INSERT INTO calint VALUES ('2003-04-11', '25000.00', '14.00', '0.00');
INSERT INTO calint VALUES ('2003-04-12', '25000.00', '14.00', '0.00');
INSERT INTO calint VALUES ('2003-04-13', '25000.00', '14.00', '0.00');
INSERT INTO calint VALUES ('2003-04-14', '25000.00', '14.00', '0.00');
INSERT INTO calint VALUES ('2003-04-15', '25000.00', '14.00', '0.00');
INSERT INTO calint VALUES ('2003-04-16', '25000.00', '13.80', '0.00');
INSERT INTO calint VALUES ('2003-04-17', '25000.00', '13.75', '0.00');
INSERT INTO calint VALUES ('2003-04-18', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-19', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-20', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-21', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-22', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-23', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-24', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-25', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-26', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-27', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-28', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-29', '25000.00', '13.50', '0.00');
INSERT INTO calint VALUES ('2003-04-30', '25000.00', '13.50', '0.00');

Any help would be appreciated.

Thanks again.

Be happy. 😉

[stolzyboy]

you may have this, but it's not in the code you showed, you still need to run the query for $graba

$result = mysql_query($graba) or die ("could not update")

just a quick thoughy

[tomhath]

All you did was assign a string with the statement in it to variable $graba. You never executed the 'update' with a mysql_query :mad: