I'm writing an application that will display the contents of a db in the browser, including the db-assigned id number. The user can then enter the id number in a form and the browser will display the record corresponding to that id number, with the data in editable text fields.

The user edits the text fields and submits to an 'update' script using POST, and the update script puts the new values back into the database. In the update script, I'm trying to access the field names and values in the $_POST array, and update the db using a loop:

while ($data = each($_POST)) {
$name = $data[ 'key' ];
$value = $data[ 'value' ];
echo $name, $value;
$result = mysql_query("UPDATE tablename SET $name = $value WHERE ID=$id") or die ("unable to update record");

The echo statement shows me that the script dies on the first time through the loop.

The application must be on line this week. Does anyone have any suggestions?

Many thanks,

Robbie Staufer
1850 Table Mesa Dr. Rm. 42
Boulder, CO. 80305
(303) 497-1836

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to