Having performed a search to retrieve information from the database for update and made changes to the form information I resubmit the data using 'ud_' prefixes to the fields so that the original fields can be updated cleanly. Anyway to cut a long story short, the final update page that make the changes to the database is not working for some reason and although I have used code almost identical to this on several occassions before I cannot see why it is not working. I am also getting no errors in the web logs either. Does any have any ideas where the problem is in my code. Here it is and thanks to all who reply:
<html>
<body>
<?
$ud_id=$POST['ud_id'];
$ud_depassrisk=$POST['ud_depassrisk'];
$ud_control=$POST['ud_control'];
$ud_status=$POST['ud_status'];
$ud_noncompliance=$POST['ud_noncompliance'];
$ud_comments=$POST['ud_comments'];
$ud_reviewer=$POST['ud_reviewer'];
$ud_review_date=$POST['ud_review_date'];
$ud_control_id=$_POST['ud_control_id'];
$ud_depassriskcontrol="$ud_depassrisk - $ud_control";
$db='risk';
$link = mysql_connect('localhost', 'root', '');
if (! $link) die("Couldn't connect to MySQL");
mysql_select_db($db , $link) or die("Couldn't open $db: ".mysql_error());
$query="Update controls SET control='$ud_control', review_date='$ud_review_date', reviewer='$ud_reviewer', comments='$ud_comments', noncompliance='$ud_noncompliance', depassriskcontrol='$ud_depassriskcontrol', status='$ud_status' where control_id='$ud_control_id'";
$result=mysql_query($query);
echo "Details Updated";
mysql_close($link);
?>
<form method="POST" action="controls_updates_form.php">
<input type="submit" value="Change Another">
</form>
<br>
</body>
</html>
