UPDATE table problem....

[tony_l]

I have tried on several occasions to write and re-write this code, and I have given up. I need to kbnow how to best do this-

I have a table with several profiles in it. I want the user to be able to modify their profile using a form.

I figured that if you place the Value like this-

<input type="text" name="hobbies" value="$hobbies">

($hobbies assigned from the database).

I thought that if I did this, then the field would populate with the value that was in the database, and then they could just change the information in the field and the form action script would then change the information in the database. But it never updated the table.

Does anyone have a suggestion as to how I could do this?

[Anon]

Sounds like you do not have an "Update" statement on the next page. Where <form action="somefile.php">. In the somefile.php, you need to execute an Update statement.

[lensta]

you need to submit the form to a new PHP script that opens the database and runs an update.:

$db = mysql_connect($servername, $username, $password)
or die ("Couldn't connect to Database.");

mysql_select_db("tablename", $db) or die ("Couldn't select tablename");

$updatesql = "UPDATE tablename SET hobbies='$hobbies' WHERE table_ID=$id";

mysql_query($updatesql) or die ("Could not update $hobbies");

You should be able to modify the above code to do what you want.