Then it's an SQL problem and not a PHP problem
-----Original Message-----
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:40
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] UPDATE is NOT working.... I cannot figure out why
Here is the code:
<?
if ((!$FirstName) || (!$LastName)) {
header("Location: http://www.feminineforum.com/admin/pick_modcontact.php";);
exit;
} else {
session_start();
}
if ($valid != "yes") {
header("Location: http://www.feminineforum.com/admin/contact_menu.php";);
exit;
} else {
session_register('valid');
}
$db_name = "feminineforum";
$table_name = "tblmembers";
$connection = @mysql_connect ("localhost", "feminine", "krmc33") or die
("Couldn't connect.");
$db = @mysql_select_db ($db_name, $connection) or die("Couldn't select
database.");
$sql = "UPDATE $table_name
SET
FirstName = \"$FirstName\",
LastName = \"$LastName\",
Address1 = \"$Address1\",
Address2 = \"$Address2\",
City = \"$City\",
State = \"$State\",
Zip = \"$Zip\",
HomePhone = \"$HomePhone\",
WorkPhone = \"$WorkPhone\",
Fax = \"$Fax\",
Email = \"$Email\",
UserId = \"$UserId\",
Password = \"$Password\",
WHERE ID = \"$ID\"
";
$result = @mysql_query($sql, $connection) or die("Couldn't execute query.");
?>
<HTML>
<HEAD>
<TITLE>Feminine Forum Contact Management System: Contact Updated</TITLE>
</HEAD>
<BODY>
<h1>Feminine Forum Contact Management System</h1>
<h2><em>Modify a Contact - Contact Updated</em></h2>
<P>The following information was successfully updated in <? echo
"$table_name"; ?></p>
<table cellspacing=3 cellpadding=5>
<tr>
<th>NAME & ADDRESS INFORMATION</th>
<th>OTHER CONTACT/PERSONAL INFORMATION</th>
</tr>
<tr>
<td valign=top>
<P><STRONG>First Name:</STRONG><BR>
<? echo "$FirstName"; ?></P>
<P><STRONG>Last Name:</STRONG><BR>
<? echo "$LastName"; ?></P>
<P><STRONG>Address Line 1:</STRONG><BR>
<? echo "$Address1"; ?></P>
<P><STRONG>Address Line 2:</STRONG><BR>
<? echo "$Address2"; ?></P>
<P><STRONG>City:</STRONG><BR>
<? echo "$City"; ?></P>
<P><STRONG>State:</STRONG><BR>
<? echo "$State"; ?></P>
<P><STRONG>Zip:</STRONG><BR>
<? echo "$Zip"; ?></P>
</td>
<td valign=top>
<P><STRONG>Home Telephone Number:</STRONG><BR>
<? echo "$HomePhone"; ?></P>
<P><STRONG>Work Telephone Number:</STRONG><BR>
<? echo "$WorkPhone"; ?></P>
<P><STRONG>E-mail Address:</STRONG><BR>
<? echo "$Email"; ?></P>
<P><STRONG>UserId:</STRONG><BR>
<? echo "$UserId"; ?></P>
<P><STRONG>Password:</STRONG><BR>
<? echo "$Password"; ?></P>
</td>
</tr>
<tr>
<td align=center colspan=2><br>
<p><a href="contact_menu.php">Return to Main Menu</a></p>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
The query fails for some unknown reason. I have tried with and without the
double qoutes, and with single qoutes. with the mysql_query()
function..still fails.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
