RE: [PHP] PHP/MYSQL query error

2002-08-26 Thread Jay Blanchard
[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.

Re: [PHP] PHP/MYSQL query error

2002-08-26 Thread Chris Crane
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

Re: [PHP] PHP/MYSQL query error

2002-08-26 Thread Chris Crane
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

Re: [PHP] PHP/MYSQL query error

2002-08-26 Thread Justin French
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

Re: [PHP] PHP/MYSQL query error

2002-08-26 Thread Chris Crane
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

Re: [PHP] PHP/MYSQL query error

2002-08-26 Thread Chris Crane
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]...