[Resolved] Replace INTO or Insert INTO Query Error

[spudmaster]

I have been trying use a Replace INTO query work without much success. I get an error when I execute via command line or webpage. I have included a sample with values to fill a row. I am using MySQL 4.1.10a. Anyone see the error in the query? I get the same error with Insert INTO.

I get the following parse error and cannot track it down:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'check,date_created) VALUES ('2507',0,now(),'91',1,'','','','',0,'name',0,1,1,' at line 3

MySQL documentation as follows;

Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)

Message: %s near '%s' at line %d

My query. I am trying to insert data from an online form into the database for a conference registration.

REPLACE INTO Registrants (MbrID,Registration_Number,Registration_Year,Membership_Type,
Registration,daily_9aug,daily_10aug,daily_11aug,daily_12aug, Spousal_Workshop,spouse_name,Prayer_Breakfast,Banquet,Pres_Reception,Amount,salmon,chicken,MCLunch,CGLunch,USNLunch,
veg_lunch_9aug,veg_lunch_10aug,veg_lunch_11aug,veg_prayer_breakfast,veg_banquet,amt_due,paid_dues,check,date_created) VALUES ('2507',0,now(),'91',1,'','','','',0,'my wife',0,1,1,0,1,,
0,0,0,0,0,0,0,0,0,Y,'N',now())

It seems to be straight forward :bemused:

[nemonoman]

The 2 commas in sequence

1,,0
indicate a missing value.

[Lars_Berg]

check is a reserved word in SQL. Change the name.

[spudmaster]

Revised query to replace "CHECK" and put in value as suggested. Both suggestions resolved errors. Query now looks like it does below. I will have to find the cause of the missing error. Thanks

REPLACE INTO Registrants( MbrID, Registration_Number, Registration_Year, Membership_Type, Registration, daily_9aug, daily_10aug, daily_11aug, daily_12aug, Spousal_Workshop, spouse_name, Prayer_Breakfast, Banquet, Pres_Reception, Amount, salmon, chicken, MCLunch, CGLunch, USNLunch, veg_lunch_9aug, veg_lunch_10aug, veg_lunch_11aug, veg_prayer_breakfast, veg_banquet, amt_due, paid_dues, check_pay, date_created )
VALUES (
'2507', 0, 'date', '91', 1, '', '', '', '', 0, 'my wife', 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Y', 'N', 'date'
)

[nemonoman]

Check the following and make sure it does what you want -- the top few settings look doubtful to me.

Also after your query
$result=mysql_query($myquery);
echo mysql_error(); //<<< add this
to see why it's failing.

INSERT INTO Registrants
SET
MbrID='2507',
Registration_Number= 0,
Registration_Year= 'date',
Membership_Type= '91',
Registration= 1,
daily_9aug= '',
daily_10aug= '',
daily_11aug= '',
daily_12aug= '',
Spousal_Workshop= 0,
spouse_name= 'my wife',
Prayer_Breakfast= 0,
Banquet= 1,
Pres_Reception= 1,
Amount= 0,
salmon= 1,
chicken= 0,
MCLunch= 0,
CGLunch= 0,
USNLunch= 0,
veg_lunch_9aug= 0,
veg_lunch_10aug= 0,
veg_lunch_11aug= 0,
veg_prayer_breakfast= 0,
veg_banquet= 0,
amt_due= 0,
paid_dues= 'Y',
check_pay= 'N',
date_created = 'date'