RE: [PHP-WIN] Julie Meloni's Modified Contact management script
| From: | Ross Fleming | Date: | Mon, 19 Nov 2001 20:03:30 +0000 |
| Subject: | RE: [PHP-WIN] Julie Meloni's Modified Contact management script | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-10510@lists.php.net to get a copy of this message | ||
You're missing an open parenthesis in the insert part...
$sql = "INSERT INTO tblmembers ( ID, etc....
Ross
-----Original Message-----
From: Todd Williamsen [mailto:todd@williamsen.net]
Sent: 19 November 2001 20:00
To: php-windows@lists.php.net
Subject: [PHP-WIN] Julie Meloni's Modified Contact management script
I cannot figure out why the mysql_query is not working. Everything id done
according to Julie's book and I end up with the "Couldn't execute query"
error
Here is the script:
<?
if ((!$FirstName) || (!$LastName)) {
header("Location: http://localhost/show_addcontact.php");
exit;
} else {
session_start();
}
if ($valid != "yes") {
header("Location: http://localhost/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 = "INSERT INTO tblmembers
ID, FirstName, Initial, LastName, Address1, Address2, City, State,
Zip, HomePhone, WorkPhone, Fax, Email, UserId, Password)
VALUES
('$FirstName', '$Initial', '$LastName', '$Address1',
'$Address2', '$City',
'$State', '$Zip', '$HomePhone', '$WorkPhone',
'$Fax', '$email',
'$UserId', '$Password')";
$result = @mysql_query ($sql, $connection) or die ("couldn't execute
query.");
?>
<HTML>
<HEAD>
<TITLE>Feminine Forum Contact Management System</TITLE>
</HEAD>
<BODY>
<h1>Feminine Forum Contact Management System</h1>
<h2><em>Add a Contact - Contact Added</em></h2>
<P>The following information was successfully added to <? 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>Zip/Postal Code:</STRONG><BR>
<? echo "$Zip";
?>
</P>
</td>
<td valign=top>
<P><STRONG>Home Telephone Number:</STRONG><BR>
<? echo "$prim_tel"; ?></P>
<P><STRONG>Work Telephone Number:</STRONG><BR>
<? echo "$sec_tel"; ?></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>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
For additional commands, e-mail: php-windows-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net