Thanks to all who have helped in the past. This is my update database page:
the table name and fields have been checked thoughly and are correct in syntax.
i can't understand why my database does not get updated.
I receive no error messages.
when i subit the edited form i just get a blank white page.
Can anyone help ? thankyou.
<?
session_start();
// check session variable
if (session_is_registered("valid_user"))
{
if ($SUBMIT) {
//Set variables
$Host = "localhost";
$User = "********";
$Password = "**";
$DBName = "endofthe_BeyondGallery";
$Link = mysql_connect ($Host, $User, $Password);
$query = "UPDATE News SET date = '$Array[date]' , header = '$Array[header]', news = '$Array[news]' WHERE newsid=$id";
$result = mysql_query($query);
if ($result)
print ("\n");
print ("<head>\n");
print ("<title>edit news</title>\n");
print ("<link rel=\"stylesheet\" type=\"text/css\" href=\"../Images/includes/front.css\">\n");
print ("</head>\n");
print ("<body bgcolor=\"#e0e0e0\">\n");
print ("News item edited successfully!\n");
print ("<meta http-equiv =\"Refresh\" content =\"3 ; URL=front.php\">\n");
mysql_close ($Link);
}else{
print ("\n");
print ("<head>\n");
print ("<title>edit news</title>\n");
print ("<link rel=\"stylesheet\" type=\"text/css\" href=\"../Images/includes/front.css\">\n");
print ("</head>\n");
print ("<body bgcolor=\"#e0e0e0\">\n");
print ("<table width=\"100%\">\n");
print ("<tr>\n");
print ("<td align=\"center\">\n");
print ("<br><br>\n");
print ("<p><b>// Edit item</b><br><br><br></p>\n");
print ("</td>\n");
print ("</tr>\n");
print ("<tr height=\"20\">\n");
print ("<td align=\"center\">\n");
print (" \n");
print ("</td>\n");
print ("</tr>\n");
// content of this page goes next
//Set variables
$Host = "localhost";
$User = "****";
$Password = "**";
$DBName = "endofthe_BeyondGallery";
$TableName = "News";
$Link = mysql_connect ($Host, $User, $Password);
$Query = "Select * FROM $TableName WHERE newsid='$id'";
$Result = mysql_db_query ($DBName, $Query, $Link);
// get results from database
print ("<FORM ACTION=\"edit2news.php?newsid='$id'\" METHOD=POST>\n");
print ("<table align=\"left\" width=\"500\">\n");
while ($Row = mysql_fetch_array($Result)) {
print ("<tr>\n");
print ("<td align=\"justify\">\n");
print ("<TEXTAREA NAME=\"Array[date]\" ROWS=1 COLS=10>$Row[date]</text>\n");
print ("</td>\n");
print ("</tr>\n");
print ("<tr>\n");
print ("<td align=\"justify\">\n");
print ("<TEXTAREA NAME=\"Array[header]\" ROWS=4 COLS=75>$Row[header]</text>\n");
print ("</td>\n");
print ("</tr>\n");
print ("<tr>\n");
print ("<td align=\"justify\">\n");
print ("<TEXTAREA NAME=\"Array[news]\" ROWS=10 COLS=75>$Row[news]</text>\n");
print ("</td>\n");
print ("</tr>\n");
}
print ("</table>\n");
print ("</body>\n");
print ("\n");
print ("<INPUT TYPE=SUBMIT NAME=\"SUBMIT\" VALUE=\"Submit!\">\n");
print ("</FORM>\n");
mysql_close ($Link);
}
}else{
echo "<p>You are not logged on.</p>\n";
echo"<p>Only the administrator can enter here.</p>\n";
}
?>
