[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.
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
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
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
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
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]...
6 matches
Mail list logo