call a record to a form and update mysql

[Anon]

I have managed to store records in a database (mysql) and display them to a webpage. I would like to know how I can retrieve a certain record from the database. The record would obviously need to fill out my origainal form, with an update button on the bottom, which updates the current record.

How is this done.

These are the variables stored in my database.

$name
$address
$postcode

[Anon]

just make a standard form and put text fields in it. Set the value of those fields with the variables you pull from the database, like so:

<INPUT TYPE="TEXT" NAME="name" VALUE="<? echo $name ?>">

then put in a submit button and make your action script UPDATE the records in the DB instead of INSERT.