[snip]
/* Performing SQL query */
$query = "INSERT INTO SignupRequests ('FirstName', 'LastName',
'Address1', 'Address2',
'City', 'State', 'Zip', 'Email', 'Phone', 'ContactMethod', 'Date',
'IP', 'Status', 'Comments')
VALUES ('', 'Chris', 'Crane', '655 Talcottville Road', 'Apt. 185',
'Vernon', 'CT', '06066', '[EMAIL PROTECTED]',
'860-659-6464', 'Email', 'August 25, 2002', '64.252.232.82', 'Newly
Requested', 'Testing')";
$result = mysql_query($query) or die("Query failed");
[/snip]
Have you printed the query to make sure that the syntax is right? The first
thing that I see is that there are 13 items in your INSERT statement and 15
items in your VALUES statement ... these must match in order for the query
to work.
HTH!
Jay
Ask smart questions:
http://www.tuxedo.org/~esr/faqs/smart-questions.html
Top Questions on php-general;
(Answers can be found by RTFM, STFW, or STFA,
save for #3 and #6 which can probably be found
the same way, since they are usually one of the
other questions on this list.)
1. How can I make file uploads work?
2. How come my form will not pass variables?
3. HELP! HELP! Please HELP!
4. Register_Globals ?!?
5. Is there a function to ... [insert thought here]?
6. Anyone see the error in this code?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
