Update query

[Tezread]

I am trying to develop an update query into a form which has an action of form action="' . $_SERVER['PHP_SELF']
I would like whatever has been entered into all the fields to update the database
here is my form:

//list box so you can choose quality name to update

if (!isset ($_POST['submit'])) 
{ 
    echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="POST">' 
        . 'quality name: <select name="quality_name">' . "\n"; 

$sql = "SELECT quality_name FROM quality_info"; 

$result = mysql_query($sql, $connection) 
    OR die(mysql_error()); 

while ($row = mysql_fetch_assoc($result)) 
{ 
    echo '<option value="' . $row['quality_name'] . '">' 
        . $row['quality_name'] . "</option>\n"; 
} 

echo '</select><input type="submit" name="submit" value="find" /></form>'; 
} 
?>

 </form>

//prepopulate the form
<?php
if (isset ($_POST['submit']) && $_POST['submit'] == 'find') 
{ 
    $result = mysql_query ("SELECT * FROM quality_info WHERE quality_name = '" . $_POST['quality_name'] . "'"); 
    if (mysql_num_rows ($result)) {$row = mysql_fetch_assoc ($result);} 
    else {echo 'no records found matching ' . $_POST['quality_name'];} 

echo ' 
<form action="' . $_SERVER['PHP_SELF'] . '" method="POST"> 



  </tr>
  <tr>
ALL FORM STUFF HERE

  </tr>
  	<td>Click the update button when you have completed your update 
    <input name="submit" type="submit" id="submit" value="update"></td>

    <td>&nbsp;</td>

  </tr>
</table>

  </form>
      '; 
}

?>

here is my update code- ive seperated it for ease of sight

// build main query from form 1
	$sql = "UPDATE quality_info SET quality_id =  NULL ";
	foreach ($_SESSION['form1_data'] as $col =>$val ){
		if($col <> 'submit'){
		$sql .=", $col = '$val' ";
		}
	}
//////////////////////////////////
mysql_query($sql, $connection) or die(mysql_error()); 

//get last insert id
$sql ="select LAST_INSERT_ID() as id from quality_info";
$result = mysql_query($sql, $connection) or die(mysql_error()); 
$row=mysql_fetch_array($result);
$id = $row['id'];

[revdev]

after the foreach, you need to tack on

 WHERE `column` = 'value';

so your whole query would be

UPDATE quality_info SET quality_id =  NULL (form values) WHERE `column` = 'value';

for example, say your table has an ID column. you would tell it to update where id = the id of the record you want to update. $row['id'] or something of the sort. i would put it in hidden field in the form, so that when they submit the form, the id of the record is in the POST array

i hope that helps, because you didn't actually state your question.