Why don't you do
$result = mysql_query($query) or die(mysql_error());
$result = mysql_query($query);
That way, instead of "Query Failed" you'll get something meaningful...
probably something that will solve the problem.
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
>> /* 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', '184.108.40.206', 'Newly
>> Requested', 'Testing')";
>> $result = mysql_query($query) or die("Query failed");
>> 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 query
>> to work.
>> Ask smart questions:
>> 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