How To Amend A Record Within A MySQL Database Using PHP?

[Jeevs B]

I would like to generate a form that retrieves a user selected record from a database and then subsequently allows you to amend the data and update the database with the amended information.
The database is already created and I know how to search for the record that requires updating.

[Nicholas J]

$sql = "UPDATE user_table SET column1=".$val1.", column2=".$val2."WHERE some_column=".$somVal;
mysql_query($sql);

Is the key to doing that.

[joe.attaboy]

You would have to write a PHP script that makes the change directly to the table using one of PHP's built-in mysql functions.

Essentiall, the procedure is similar to a query/fetch, but with the additional SQL update part.

Detailing it anymore than that would be tough, not knowing your server setup, web site setup, etc.