"Couldn't execute query" ERROR [Archive] - Hosting Matters Community Forums

Curt

02-25-2001, 02:13 AM

I have a phone directory script that I can get everything to work on except for the modify record command. When I run it I get back "Couldn't execute query" error.

Can any of you see a problem with the code below?

Thanks,
Curt

<?

if ((!$lname) || (!$fname)) {
header("Location: http://localhost/pick_modcontact.php");
exit;

} else {

session_start();

}

if ($valid != "yes") {
header("Location: http://localhost/phone/contact_menu.php");
exit;

} else {

session_register('valid');

}

$db_name = "wood_crafting_com";
$table_name = "overlook_phone";

$connection = @mysql_connect("localhost", "*****", "********") or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "UPDATE $table_name
SET
lot = \"$lot\",
lname = \"$lname\",
fname = \"$fname\",
addr = \"$addr\",
phone = \"$phone\",
cell = \"$cell\",
page = \"$page\",
email = \"$email\",
im = \"$im\",
nchild = \"$nchild\",
misc = \"$misc\",
WHERE id = \"$id\"
";

$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");

?>

<HTML>
<HEAD>
<TITLE>Overlook Contact Management System: Contact Updated</TITLE>
</HEAD>
<BODY>

<h1>Overlook Contact Management System</h1>
<h2>Modify a Contact - Contact Updated</h2>
The following information was successfully updated in <? echo "$table_name"; ?>
<table cellspacing=3 cellpadding=5>

<tr>
<th>NAME & ADDRESS INFORMATION</th>
</tr>

<tr>
<td valign=top>
Lot Number: 
<? echo "$lot"; ?>

Last Name: 
<? echo "$lname"; ?>

First Name: 
<? echo "$fname"; ?>

Address: 
<? echo "$addr"; ?>

Phone: 
<? echo "$phone"; ?>

Cell: 
<? echo "$cell"; ?>

Page: 
<? echo "$page"; ?>

Email Id: 
<? echo "$email"; ?>

AOL IM ID: 
<? echo "$im"; ?>

Children Names: 
<? echo "$nchild"; ?>

Misc: 
<? echo "$misc"; ?>
</td>
</tr>

<tr>
<td align=center colspan=2> 
<a href="contact_menu.php">Return to Main Menu</a>

</TD>
</TR>
</TABLE>

</BODY>
</HTML>