Continued from http://www.phpbuilder.com/board/showthread.php?p=10849811#post10849811
So now, when I execute equipment_edit.php?id=30, the update query is not working
// $query = "SELECT * FROM EquipmentList WHERE EquipmentID='" . $_GET['id'] . "'" or die("Error in query" . mysql_error() );
$id = $_GET['id'];
$query = "SELECT * FROM EquipmentList WHERE EquipmentID='$id'" or die("Error in query" . mysql_error() );
$result = mysql_query($query) or die("Error in query result. Error: " . mysql_error() );
$row = mysql_fetch_array($result);
?>
<form action="equipment_edit.php?id=<?php echo $id ?>" method="post" name="edit_equip" id="edit_equip" onSubmit="return validateForm()">
<input type="hidden" name="id" value="<?php echo $id ?>" />
Hours: <input type="text" name="Hours" value="<?php echo $row["OilChangeHours"] ?>" size="25" />
<input type="submit" name="edit" value="Update Profile" class="small" />
</form>
[code=php]
if ($edit) {
$sql = "UPDATE EquipmentList SET
OilChangeHours = '$Hours'
WHERE EquipmentID='$id'" or die("Query error: " . mysql_error() );
$result = mysql_query($sql) or die("Error in query result");
print "<h1>Record successfully updated.</h1>";
echo '<META HTTP-EQUIV="Refresh" Content="1; URL=equipment.php">';
}
else {
print "UPDATE EquipmentList SET OilChangeHours = '$Hours' WHERE EquipmentID='$id'" or die("Query error: " . mysql_error() );
}
The result upon submission is:
UPDATE EquipmentList SET OilChangeHours = '' WHERE EquipmentID='30'
Now the UPDATE query is neither executing nor picking up the form field values.
I've been experimenting with $_GET['id'] and I can't seem to figure out what i'm doing wrong.
