MySql syntax error, insert

Question

I'm trying to insert user inputted values as well as a string that is a combination of the month year of the start date + the user inputted quarter. What is wrong. please help!!!!!

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "addUser")) {
$date=  $_POST['start_date'];
$d=date_parse_from_format("Y-m-d",$date);
  $insertSQL = sprintf("INSERT INTO contacts (USER_NAME, START_DATE, THREE_MONTH, SIX_MONTH, TWELVE_MONTH, QUARTER, ORDER) VALUES (%s, %s, %s, %s, %s, %s,'".$d["month"].$d["year"].$_POST['quarter']."' )",
                       GetSQLValueString($_POST['user'], "text"),
                       GetSQLValueString($_POST['start_date'], "date"),
                       GetSQLValueString($_POST['3month'], "date"),
                       GetSQLValueString($_POST['6month'], "date"),
                       GetSQLValueString($_POST['12month'], "date"),
                       GetSQLValueString($_POST['quarter'], "text"));

error i'm getting:

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 'ORDER) VALUES ('boobz', '2013-11-22', '2013-11-29', '2013-11-23', '2013-11-02', ' at line 1

ORDER is a reserved word in SQL. If you really must use it, you'll need to quote it with backticks; but it makes for a much easier time if you avoid naming columns and tables after reserved words in the first place. — andrewsi
– andrewsi, Commented Jul 24, 2013 at 19:19
@Shredder - I can generally only pop on to SO for a couple of minutes now and again; I don't like putting up a half-hearted answer, so I mostly stick to comments. — andrewsi
– andrewsi, Commented Jul 25, 2013 at 1:11

gen_Eric · Accepted Answer · 2013-07-24 19:23:43Z

2

ORDER is reserved word. Use ` or better change it to something else in database structure. That's better practice.

edited Jul 24, 2013 at 19:23

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

answered Jul 24, 2013 at 19:20

Flash Thunder

12.1k10 gold badges55 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Geoffrey · Accepted Answer · 2013-07-24 19:21:13Z

2

Order is a reserved word, you need to quote it with backticks:

INSERT INTO contacts (USER_NAME, START_DATE, THREE_MONTH, SIX_MONTH, TWELVE_MONTH, QUARTER, `ORDER`)

Or better yet, do not use the reserved word and use something more sensible.

answered Jul 24, 2013 at 19:21

Geoffrey

11.4k3 gold badges37 silver badges50 bronze badges

Collectives™ on Stack Overflow

MySql syntax error, insert

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related