update results page

[buzzby]

http://www.buildingdoctors.co.uk/formview.php this is the results screen. you can input a number and see the corresponding record. what i want to do now is be able to update the records. there is a notes section whereby all updates and extra notes can be placed. i need a code or if statement (or a combination) in order for the update to work. i got 3 submit buttons with this code:

$OFFSET = $_POST['offset'] ? $_POST['offset'] : 1; 
if($_POST['button'] == 'next'){
$OFFSET++;
}else{
$OFFSET--;
}
if($_POST['button'] == 'go'){
$OFFSET = $_POST['offset'];
}

i think i need a 4th button called UPDATE. i want to update the record. any ideas on how to do this?

[devinemke]

ok, just add another submit button called "update" and do:

// assuming the table is called "table" and the primary key field is called "id" and is submitted along with the POST data

if (isset($_POST['submit']) && $_POST['submit'] == 'update')
{
	foreach ($_POST as $key => $value)
	{
		$sql_array[$key] = "$key = '$value'";
	}
	mysql_query('UPDATE table SET ' . implode(',', $sql_array); . ' WHERE id = ' . $_POST['id']);	
}

note: this example obviously does not do any error checking, validation, etc...