I'm posting a complete form code that allows a person to do two functions within one form. They can either edit or delete a reocord. My delete function is working just fine. But for some reason my update sql is not kicking in and updating the record when I click the submit button. Here is the complete form code with table and field names as well as the database connection. Can anyone help me on this?! It's so close to being finished. I have in bold where I think the problem is.
<body bgcolor="#eeeeee" text="#000000">
<?
include ("Header.inc.php");
?>
<html>
<body>
<table align="center" border=1 >
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("CommunityServiceTracking",$db);
if ($submit) {
print $ANumberID;
// here if no CommID then adding else we're editing
if ($CommID) {
$sql = "UPDATE activitytracking SET ANumber='$ANumber',FirstName='$FirstName',LastName='$LastName',Department='$Department',
TeamLeader='$TeamLeader',DateOfService='$DateOfService',NumberOfHours='$NumberOfHours',ActivityType='$ActivityType',
Org='$Org',Description='$Description',City='$City',TimeTakenWhen='$TimeTakenWhen','$siteID' WHERE CommID=$CommID";
} else {
$sql = "INSERT INTO activitytracking (ANumber,FirstName,LastName,Department,TeamLeader,DateOfService,NumberOfHours,
ActivityType,Org,Description,City,TimeTakenWhen,siteID) VALUES ('$ANumber','$FirstName','$LastName','$Department',
'$TeamLeader','$DateOfService','$NumberOfHours','$ActivityType','$Org','$Description','$City','$TimeTakenWhen',$siteID')";
}
// run SQL against the DB
$result = mysql_query($sql);
echo "Record updated / edited!<p>";
} elseif ($delete) {
[color=blue]// delete a record[/color]
$sql = "DELETE FROM activitytracking WHERE CommID=$CommID";
$result = mysql_query($sql);
echo "Record has been deleted!";
} else {
// this part happens if we don't press submit
if (!$CommID) {
// print the list if we are not editing
$result = mysql_query("SELECT FROM activitytracking WHERE ANumber Like '%".$_POST[KeyANumber]."%'",$db);
//$result = mysql_query("SELECT FROM activitytracking",$db);
while ($myrow = mysql_fetch_array($result)) {
printf("<a href=\"%s?CommID=%s\">(EDIT)%s \ %s %s %s %s %s %s %s %s %s %s %s %s</a> \n", $PHP_SELF, $myrow["CommID"], $myrow["ANumber"], $myrow["FirstName"], $myrow["LastName"], $myrow["Department"], $myrow["siteID"], $myrow["TeamLeader"], $myrow["DateOfService"], $myrow["NumberOfHours"], $myrow["ActivityType"], $myrow["Org"], $myrow["Description"], $myrow["City"], $myrow["TimeTakenWhen"]);
printf("<a href=\"%s?CommID=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["CommID"]);
}
}
?>[/b]
<P>
<P>
<form method="post" action="<?php echo $PHP_SELF?>">
<?php
if ($CommID) {
// editing so select a record
$sql = "SELECT * FROM activitytracking WHERE CommID=$CommID";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$CommID = $myrow["CommID"];
$ANumber = $myrow["ANumber"];
$FirstName = $myrow["FirstName"];
$LastName = $myrow["LastName"];
$Department = $myrow["Department"];
$TeamLeader = $myrow["TeamLeader"];
$DateOfService = $myrow["DateOfService"];
$NumberOfHours = $myrow["NumberOfHours"];
$ActivityType = $myrow["ActivityType"];
$Org = $myrow["Org"];
$Description = $myrow["Description"];
$City = $myrow["City"];
$siteID = $myrow["siteID"];
$TimeTakenWhen = $myrow["TimeTakenWhen"];
[b][color=blue]// print the CommID and siteID for editing[/color][/b]
?>
<input type=hidden name="CommID" value="<?php echo $CommID ?>">
<input type=hidden name=siteID value=<?print $siteID;?>>
<?php
}
?>
</table>
<Table border=1 align="center">
<tr>
<td colspan="2"><strong>Select the record you wish to edit or delete from
the <br>
list above using the EDIT or DELETE link of each record.</strong></td>
</tr>
<tr>
<td width="225"> ANumber </td>
<td width="144"> <input type="Text" name="ANumber" value="<?php echo $ANumber ?>"> </td>
</tr>
<tr>
<td> First Name </td>
<td> <input type="Text" name="FirstName" value="<?php echo $FirstName ?>">
</td>
</tr>
<tr>
<td> Last Name </td>
<td> <input type="Text" name="LastName" value="<?php echo $LastName ?>"> </td>
</tr>
<tr>
<td> Department </td>
<td> <input type="Text" name="Department" value="<?php echo $Department ?>">
</td>
</tr>
<tr>
<td> Team Leader </td>
<td> <input type="Text" name="TeamLeader" value="<?php echo $TeamLeader ?>">
</td>
</tr>
<tr>
<td> Date Of Service </td>
<td> <input type="Text" name="DateOfService" value="<?php echo $DateOfService ?>">
</td>
</tr>
<tr>
<td> Hours Involved </td>
<td> <input type="Text" name="NumberOfHours" value="<?php echo $NumberOfHours ?>">
</td>
</tr>
<tr>
<td> Activity Involved </td>
<td> <input type="Text" name="ActivityType" value="<?php echo $ActivityType ?>">
</td>
</tr>
<tr>
<td> Organization Involved </td>
<td> <input type="Text" name="Org" value="<?php echo $Org ?>"> </td>
</tr>
<tr>
<td> Comments </td>
<td> <input type="Text" name="Description" value="<?php echo $Description ?>">
</td>
</tr>
<tr>
<td> When Involved </td>
<td> <input type="Text" name="TimeTakenWhen" value="<?php echo $TimeTakenWhen ?>">
</td>
</tr>
</Table>
<Table align="center">
<input type="Submit" name="submit" value="Update Record">
<div align="center"><a href="search.php">A New Search</a></div>
</form>
<?php
}
?>
</body>
</html>
