Table Update Problem

[Claelia]

I've been working on this issue for some months and have gotten no where but frustrated and confused as to why things aren't working. I'm trying to do the following:

1. Pull data out of the database
2. Populate the fields of an HTML form with this data
3. Allow the user to change data
4. Update the data according the the field changes the user makes

I've gotten more or less to step 4 of this process and I'm beyond stuck. I can get the data to populate the fields of the table but whenever I hit the submit button on the form I am unable to get it to send the new data to the database...any ideas (code is below)?

function Edit($autoid, $password, $email)
{

include "settings.cfg";

DBConnect($dbserver, $dbuser, $dbpassword);

mysql_select_db("mudlistings")
or die("Error: ".mysql_error());

$searchresult = mysql_query("SELECT tbl_MudData.MudName, tbl_MudData.WebAddress,
tbl_MudData.IPAddress, tbl_MudData.Port, tbl_MudData.MudAdmin, tbl_MudData.Password,
tbl_MudData.AdminEmail, tbl_MudData.Location, tbl_MudData.Language,
tbl_MudData.StartDate, tbl_MudData.CodeBase, tbl_MudData.DevelStatus,
tbl_MudData.AveragePlayers, tbl_MudData.HiringBuilders,
tbl_MudData.HiringCoders, tbl_MudData.HiringAdmins,
tbl_MudData.StockAreas, tbl_MudData.Size, tbl_MudData.Clans,
tbl_MudData.Guilds, tbl_MudData.Orders, tbl_MudData.PlayerKilling,
tbl_MudData.ExtendedClasses, tbl_MudData.ExtendedRaces,
tbl_MudData.Questing, tbl_MudData.ANSI, tbl_MudData.RolePlaying,
tbl_MudData.Comments, tbl_MudData.Approved FROM tbl_MudData WHERE tbl_MudData.MudAutoID = '$autoid' AND
tbl_MudData.Password = '$password' AND tbl_MudData.AdminEmail = '$email' ")
or die("Error: ".mysql_error());

echo "<FORM name=\"tbl_MudData\" method=\"post\" action=\"modules.php?name=Mud_Listings\" target=\"_self\">";

while ($row = mysql_fetch_array($searchresult))

      {

echo "<table width=\"700\" bgcolor=\"#909090\" border=\"1\">";

echo "<tr><td align=\"right\">";

echo "Name of Mud: <INPUT type=\"text\" Name=MudName value=\"".$row["MudName"]."\">";
echo "</td><td align=\"right\">";
echo "Web Site Address: <INPUT type=\"text\" Name=WebAddress value=\"".$row["WebAddress"]."\">";
echo "</td></tr>";

[SNIP]

if ($update)
{

DBConnect($dbserver, $dbuser, $dbpassword);

mysql_select_db("mudlistings")
or die("Error: ".mysql_error());
mysql_query("UPDATE tbl_MudData SET MudName=\"$MudName\", WebAddress=\"$WebAddress\",
IPAddress=\"$IPAddress\", Port='$Port', MudAdmin=\"$MudAdmin\", AdminEmail=\"$AdminEmail\",
Password=\"$Password\", Location=\"$Location\", Language=\"$Language\", StartDate=\"$StartDate\",
CodeBase=\"$CodeBase\", DevelStatus=\"$DevelStatus\", AveragePlayers=\"$AveragePlayers\",
HiringBuilders=\"$HiringBuilders\", HiringCoders=\"$HiringCoders\", HiringAdmins=\"$HiringAdmins\",
StockAreas=\"$StockAreas\", Size=\"$Size\", Clans=\"$Clans\", Guilds=\"$Guilds\", Orders=\"$Orders\",
PlayerKilling=\"$PlayerKilling\", ExtendedClasses=\"$ExtendedClasses\", ExtendedRaces=\"$ExtendedRaces\",
Questing=\"$Questing\", ANSI=\"$ANSI\", RolePlaying=\"$RolePlaying\", Comments=\"$Comments\" WHERE MudAutoID = '$autoid'")
or Die("Error: ".mysql_error());
DBClose($dblink);

    }

echo "<INPUT TYPE=\"submit\" name=update value=\"Update\">";

echo "</FORM>";

echo "</td></tr>";

echo "</table>";

}

}

It should be noted that I get no error messages what so ever when I hit update, it simply goes back to the main display and doesn't update anything.

[mogster]

You should try to use single quotes in the update-query.
Not like this:
MudName=\"$MudName\", WebAddress=\"$WebAddress\",
but:
MudName='$MudName', WebAddress='$WebAddress',

knutm

[Sphynx]

To debug, build your UPDATE query string into one var at the top of your page, not inside your if statement. Name the var $sql or something, then echo it just inside your if($update){... } like so...

if($update){
  echo $sql."<br />";
  ...
}

This feedback will tell you two things: 1) it will show you any syntax issues with your query string. 2) if your query string is not echoed, then you are not meeting your IF condition for update.

If you don't get $sql echoed, then next echo $update. Go backwards like this and give yourself some debugging feedback to see where error is. 🙂