PHP Form Overwrites MySQL Table Data

[vigiw]

Hello,

 

I have a PHP form sending data to a MySQL table, and I am wondering if I can add some sort of code to the PHP page that will make the form data overwrite any potentially old data already in the table.

 

This sounds simple enough, but I can't put my finger on it.  ???

 

Thanks.

[trq]

Use an UPDATE statement. eg;

 

UPDATE tbl SET fld = 'new data';

[vigiw]

Oh of course, update... But...

 

Can I replace the following "Insert Into":

 

$sql = "INSERT INTO `" . $table_name . "`

 

to just Update

 

Because after that line, i have all the fields listed, there is a number of them.

 

Thanks.

[trq]

No. The syntax for an UPDATE is different to an INSERT. (As shown above)

[vigiw]

Ok, so with this--

 

UPDATE tbl SET fld = 'new data';

 

Should I replace the insert commands with--

 

$sql = "UPDATE" . "$table_name" SET field1 = 'new data';

$sql = "UPDATE" . "$table_name" SET field2 = 'new data';

 

and so on for each field?

[trq]

There is such a thing as the mysql manual.

 

Simply put, you can use....

 

$sql = "UPDATE $table_name SET field1 = 'new data', fld2 = 'new data';

[vigiw]

Why thank you for that link.