I got it working. It did not like the single quotes around the column names.
"Chris Crane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Thank you. I will try that. > "Justin French" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Why don't you do > > > > $result = mysql_query($query) or die(mysql_error()); > > > > or > > > > $result = mysql_query($query); > > echo mysql_error(); > > > > That way, instead of "Query Failed" you'll get something meaningful... > > probably something that will solve the problem. > > > > > > Justin French > > > > > > on 26/08/02 11:55 PM, Chris Crane ([EMAIL PROTECTED]) wrote: > > > > > 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 > > > 003201c24d07$b8560470$8102a8c0@000347D72515">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', '[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
