I've been trying to create a program to put cemetery records into a database.
In creating the Modify Records section, I have three files: pick_modrecords.php, show_modrecords.php and do_modrecords.php

The pick_modrecord.php file brings up a list of records from the appropriate table and allows me to select a record to modify...which goes on to the show_modrecord.php file.

The show_modrecord.php file allows me to enter/change info, but when I hit the Update Record button, it doesn't make the changes in the database and show me a confirmation that the Update has taken place (the do_modrecord.php file). Instead, it goes back to the pick_modrecord.php file for me to begin the process all over again.

Below are the three files minus the database secrets. If anyone can direct me to what needs to be changed where so this script will work, I'd be very grateful.

pick_modrecord.php:

$sql ="SELECT id, LastName, FirstName FROM $table_name ORDER BY LastName";
$result = @mysql_query($sql,$connection) or die(mysql_error());
//check the number of results
$num = @mysql_num_rows($result);
if ($num < 1) {
 //if there are no results,display message
 $display_block = "<P><em>Sorry!No results.</em></p>";
} else {
 //if results are found,loop through them
 //and make a form selection block
 while ($row = mysql_fetch_array($result)){
  $id = $row['id'];
  $LastName = $row['LastName'];
  $FirstName = $row['FirstName'];
  $option_block .="<option value=\"$id\">$LastName,$FirstName</option>";
 }
 //create the entire form block
 $display_block ="
 <FORM METHOD=\"POST\" ACTION=\"show_modrecord.php\">
 <P><strong>Contact:</strong>
 <select name=\"id\">
 $option_block
 </select>
 <INPUT TYPE=\"SUBMIT\" NAME=\"submit \"VALUE=\"Select this Record\"></P>
 </form>";
}
?>
<HTML>
<HEAD>
<TITLE>Middlebury Union Cemetery Records Management System:Modify a Record</TITLE>
</HEAD>
<BODY>
<h1>Middlebury Union Cemetery Records Management System</h1>
<h2><em>Modify a Record - Select from List</em></h2>
<P>Select a record from the list below to modify the record.</P>
<? echo "$display_block"; ?>
<br>
<p><a href="admin1.php">Return to Main Menu</a></p>
</BODY>
</HTML>

show_modrecord.php

$sql ="SELECT EndowmentNumber, Letter, LotSize, Section, LotNumber, LotOwner, LastName, FirstName, Born, Died, VeteranInfo, MiscInfo FROM $table_name WHERE id ='$_POST[id]'";
$result =@mysql_query($sql,$connection)or die(mysql_error());
//get results for display
while ($row =mysql_fetch_array($result)){
 $EndowmentNumber =$row ['EndowmentNumber'];
 $Letter =$row ['Letter'];
 $LotSize =$row ['LotSize'];
 $Section =$row ['Section'];
 $LotNumber =$row ['LotNumber'];
 $LotOwner =$row ['LotOwner'];
 $LastName =$row ['LastName'];
 $FirstName =$row ['FirstName'];
 $Born =$row ['Born'];
 $Died =$row ['Died'];
 $VeteranInfo =$row ['VeteranInfo'];
 $MiscInfo =$row ['MiscInfo'];
}
?>
<HTML>
<HEAD>
<TITLE>Middlebury Union Cemetery Records Management System:Modify a Record</TITLE>
</HEAD>
<BODY>
<h1>Middlebury Union Cemetery Records Management System</h1>
<h2><em>Modify a Record</em></h2>
<FORM METHOD="post"ACTION="do_modrecord.php">
<INPUT TYPE="hidden" name="id" value="<? echo "$_POST[id]"; ?>">
<table cellspacing=3 cellpadding=5>
<tr>
<th>LOTS & GRAVES INFORMATION</th>
</tr>
<tr>
<td valign=top>
<P><STRONG>EndowmentNumber:</STRONG><BR>
<INPUT TYPE="text" NAME="EndowmentNumber" VALUE="<? echo "$EndowmentNumber"; ?>" SIZE=5 MAXLENGTH=10></P>
<P><STRONG>Letter:</STRONG><BR>
<INPUT TYPE="text" NAME="Letter" VALUE="<? echo "$Letter"; ?>" SIZE=5 MAXLENGTH=10></P>
<P><STRONG>LotSize:</STRONG><BR>
<INPUT TYPE="text" NAME="LotSize" VALUE="<? echo "$LotSize"; ?>" SIZE=10 MAXLENGTH=10></P>
<P><STRONG>Section:</STRONG><BR>
<INPUT TYPE="text" NAME="Section" VALUE="<? echo "$Section"; ?>" SIZE=2 MAXLENGTH=5></P>
<P><STRONG>LotNumber:</STRONG><BR>
<INPUT TYPE="text" NAME="LotNumber" VALUE="<? echo "$LotNumber"; ?>" SIZE=5 MAXLENGTH=10></P>
<P><STRONG>LotOwner:</STRONG><BR>
<INPUT TYPE="text" NAME="LotOwner" VALUE="<? echo "$LotOwner"; ?>" SIZE=25 MAXLENGTH=50></P>
<P><STRONG>Last Name:</STRONG><BR>
<INPUT TYPE="text" NAME="LastName" VALUE="<? echo "$LastName"; ?>" SIZE=25 MAXLENGTH=50></P>
<P><STRONG>First Name:</STRONG><BR>
<INPUT TYPE="text" NAME="FirstName" VALUE="<? echo "$FirstName"; ?>" SIZE=25 MAXLENGTH=50></P>
<P><STRONG>Born:</STRONG><BR>
<INPUT TYPE="text" NAME="Born" VALUE="<? echo "$Born"; ?>" SIZE=10 MAXLENGTH=10></P>
<P><STRONG>Died:</STRONG><BR>
<INPUT TYPE="text" NAME="Died" VALUE="<? echo "$Died"; ?>" SIZE=10 MAXLENGTH=10></P>
<P><STRONG>VeteranInfo:</STRONG><BR>
<INPUT TYPE="text" NAME="VeteranInfo" VALUE="<? echo "$VeteranInfo"; ?>" SIZE=100 MAXLENGTH=100></P>
<P><STRONG>MiscInfo:</STRONG><BR>
<INPUT TYPE="text" NAME="MiscInfo" VALUE="<? echo "$MiscInfo"; ?>" SIZE=100 MAXLENGTH=200></P>
</td>
</tr>
<tr>
<td align=center colspan=2><br>
<P><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Update Record"></P>
<br>
<p><a href="admin1.php">Return to Main Menu</a></p>
</TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>

do_modrecord.php

$sql ="UPDATE $table_name SET
 EndowmentNumber ='$_POST[EndowmentNumber]',
 Letter ='$_POST[Letter]',
 LotSize ='$_POST[LotSize]',
 Section ='$_POST[Section]',
 LotNumber ='$_POST[LotNumber]',
 LotOwner ='$_POST[LotOwner]',
 LastName ='$_POST[LastName]',
 FirstName ='$_POST[FirstName]',
 Born ='$_POST[Born]',
 Died ='$_POST[Died]',
 VeteranInfo ='$_POST[VeteranInfo]',
 MiscInfo ='$_POST[MiscInfo]'
 WHERE id ='$_POST[id]'";
 
$result = @mysql_query($sql,$connection) or die(mysql_error());
?>
<HTML>
<HEAD>
<TITLE>My Contact Management System:Contact Updated</TITLE>
</HEAD>
<BODY>
<h1>Middlebury Union Cemetery Records Management System</h1>
<h2><em>Modify a Record - Record Updated</em></h2>
<P>The following information was successfully updated in <? echo "$table_name"; ?></P>
<table cellspacing=3 cellpadding=5><tr>
<th>LOTS & GRAVES INFORMATION</th>
</tr>
<tr>
<td valign=top>
<P><STRONG>EndowmentNumber:</STRONG><BR>
<? echo "$_POST[EndowmentNumber]"; ?></P>
<P><STRONG>Letter:</STRONG><BR>
<? echo "$_POST[Letter]"; ?></P>
<P><STRONG>LotSize:</STRONG><BR>
<? echo "$_POST[LotSize]"; ?></P>
<P><STRONG>Section:</STRONG><BR>
<? echo "$_POST[Section]"; ?></P>
<P><STRONG>LotNumber:</STRONG><BR>
<? echo "$_POST[LotNumber]"; ?></P>
<P><STRONG>LotOwner:</STRONG><BR>
<? echo "$_POST[LotOwner]"; ?></P>
<P><STRONG>Last Name:</STRONG><BR>
<? echo "$_POST[LastName]"; ?></P>
<P><STRONG>First Name:</STRONG><BR>
<? echo "$_POST[FirstName]"; ?></P>
<P><STRONG>Born:</STRONG><BR>
<? echo "$_POST[Born]"; ?></P>
<P><STRONG>Died:</STRONG><BR>
<? echo "$_POST[Died]"; ?></P>
<P><STRONG>VeteranInfo:</STRONG><BR>
<? echo "$_POST[VeteranInfo]"; ?></P>
<P><STRONG>MiscInfo:</STRONG><BR>
<? echo "$_POST[MiscInfo]"; ?></P>
</td>
</tr>
<tr>
<td align=center colspan=2><br>
<p><a href="admin1.php">Return to Main Menu</a></p>
</TD>
</TR>
</TABLE></BODY>
</HTML>

<FORM METHOD="post"ACTION="do_modrecord.php">
Try putting a space between the " and ACTION

<FORM METHOD="post"ACTION="do_modrecord.php">
Try putting a space between the " and ACTION

That was a good suggestion - thanks for the quick response. Unfortunately, it didn't solve the problem....goes right back to the pick_modrecord.php form without adding the changes.

Oh, I found my error - I had a session at the beginning of my script that had a wrong field listed - I didn't show the session in my original script to you. Sorry.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.