Problem updating database via form (PHP/HTML)

[lilbadger25]

I am trying to code a page that allows the user to edit the content that is drawn from the database. The fields show the correct data from the database, and you can type in the fields, but the database does not update when the "submit" button is clicked. It jumps to the events list page, as it should, but the information has not been changed.

My code is as follows:

Top of page
[php]
<? if (array_key_exists('_submit_check', $_POST)) {
mysql_query("UPDATE events SET eventTitle = '$eventTitle', eventInfo = '$eventInfo', eventImage = '$eventImage' WHERE eventID = '$id'");
header("Location: eventsList.php");
}
?>[/php]

Within the template
[php]<?php
mysql_select_db($database_Site, $Site);
$query = "SELECT * FROM events WHERE eventID = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$id = mysql_result($result,$i,"eventID");
$eventTitle = mysql_result($result,$i,"eventTitle");
$eventInfo = mysql_result($result,$i,"eventInfo");
$eventImage = mysql_result($result,$i,"eventImage");
?>
<form action="<? echo $PHP_SELF; ?>" method="POST">
<input type="hidden" name="_submit_check" value="1"/>
<input type="hidden" name="eventID" value="<? echo $id; ?>">
<tr>
<td valign="top"><b><font size="2" face="Arial, Helvetica, sans-serif">Title</font></b></td>
<td><input size="50" maxlength="250" type="text" name="eventTitle" value="<? echo $eventTitle; ?>">
</td>
</tr>
<tr>
<td valign="top"><b><font size="2" face="Arial, Helvetica, sans-serif">Information</font></b></td>
<td><textarea name="eventInfo" cols="40" rows="10"><? echo $eventInfo; ?></textarea>
</td>
</tr>
<tr>
<td valign="top" align="left"><font face="Arial, Helvetica, sans-serif" size="2"><b>Image</b></font></td>
<td><input size="50" maxlength="250" type="text" name="eventImage" value="<? echo $eventImage; ?>">
</td>
</tr>
<tr align="center" valign="top">
<td colspan=2><input type="Submit" name="submit" value="Update">
</td>
</tr>
</form>[/php]

Any help would be appreciated.

[mwasif]

Hi lilbadger25,

Welcome to TSDN!!!

[php]
<? if (array_key_exists('_submit_check', $_POST)) {
mysql_query("UPDATE events SET eventTitle = '$eventTitle', eventInfo = '$eventInfo', eventImage = '$eventImage' WHERE eventID = '$id'");
header("Location: eventsList.php");
}
?>[/php]

What is the value of $id and where you are assigning the value to it? To know the issue, use the following code
[PHP]<?
if (array_key_exists('_submit_check', $_POST)) {
$query = "UPDATE events SET eventTitle = '$eventTitle', eventInfo = '$eventInfo', eventImage = '$eventImage' WHERE eventID = '$id'";
mysql_query($query);
echo $query;
exit;
header("Location: eventsList.php");
}
?>[/PHP]
This will print the query. Please confirm if the printed query is correct or not.

Post back what did you get from the above code?