There are 15 columns and 15 pieces of data. In my second post I fixed this
error and pasted it into PHPMYADMIN and it worked fine, but not here...
"Chris Crane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Initially there was an error with too many values verses columns. But I
> think it was fixed. I am double checking now.
> "Jay Blanchard" <[EMAIL PROTECTED]> wrote in message
> > [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', '220.127.116.11', '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
> > thing that I see is that there are 13 items in your INSERT statement and
> > items in your VALUES statement ... these must match in order for the
> > 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