Re: PHP/MYSQL query error

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" <ccrane@inxdesign.com> wrote in message news:20020826135509.94145.qmail@pb1.pair.com... > Initially there was an error with too many values verses columns. But I > think it was fixed. I am double checking now. > > > "Jay Blanchard" <jay.blanchard@niicommunications.com> wrote in message > news:003201c24d07$b8560470$8102a8c0@000347D72515... > > [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', 'ccrane@inxdesign.com', > > '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? > > > > > >