Trying to update a record from dynamically filled text boxes

synergy

I've got a page that reads a record from a database and fills in the proper textboxes with the current variables.

I want to be able to update the variables with new information and submit it to the database.

I plan to use 2 pages to do this, one being the update page, and the other being the submit page that the form send the variables to.

How would I go about posting and retrieving the variables from the update page to the submit page properly? Would I use $_POST? This is just a typical update page.. but is driving me nuts because I can't figure it out. Thanks.

cgraz

yes. The form has the values, and when submitted, you'll have access to a variable $POST that is an array with all the values. Just use $POST to access the variables and update the database.

$query = mysql_query("UPDATE your_table SET fname='" . $_POST['fname'] . "' WHERE id='" . $_GET['id'] . "'");

I used $_GET['id'] to grab the id of the record you're updating. What you'd have to do is in your form, have something like

$row = mysql_fetch_array($select_query);

echo "<form method='post' action='process.php?id=" . $row["id"] . "'>";

// rest of form here

to get the id field out of the database and pass it in the url so you can access it on process.php

Cgraz

synergy

worked. thanks!

raouleduke

Could you take a look at what I got, I think that I am doing the same thing as you. Here is the link.

<PHP>
http://www.phpbuilder.com/board/showthread.php?s=&postid=10290559#post10290559
</PHP>

Thanks in Advance.