SQL insert error SQL syntax ... date()

Question

This is the error i'm receiving 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 ':i:s a), rec_type = '', rec_request = '1', rec_by = 'Victoria', batch_id = UC' at line 1

also i'm aware that I need to escape before inserting. I'm just testing right now.

$importwav="INSERT into names SET 
com_id = '".$word_id."',
rec_date = date(d-M-y),
rec_time = date(h:i:s a),
rec_type = '".$rec_type."',
rec_request = '1',
rec_by = '".$data[8]."',
batch_id = UCASE('".$batchid."')
";


    INSERT into names SET com_id = '87', rec_date = date(d-M-y), 
rec_time = date(h:i:s a), rec_type = '', rec_request = '1', 
rec_by = 'Victoria', batch_id = UCASE('Batch004AM')

make single rec_date field of datetime type and assign both date and time at once with rec_date=localtime. — Your Common Sense
– Your Common Sense, Commented Dec 12, 2010 at 14:42

Ignacio Vazquez-Abrams · Accepted Answer · 2010-12-12 14:44:28Z

3

You're confusing your PHP functions and your MySQL functions.

$importwav="INSERT into names SET 
com_id = '".$word_id."',
rec_date = '" . date('d-M-y') . "',
rec_time = '" . date('h:i:s a') . "',
 ...

And your SQL syntax is FUBAR.

edited Dec 12, 2010 at 14:44

answered Dec 12, 2010 at 14:37

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

2 Comments

Brian H Over a year ago

Hmmm... Inacio says your SQL syntax is FUBAR and gets 3 votes. I say your SQL syntax is improper and get a negative vote. Oh well..

Your Common Sense Over a year ago

@Brian he is wrong with that remark and the rest of the answer is okay (save for not to mention lame data format). While your answer actually helps nothing and, as the op mentioned in the comment, being used literally, can't solve the problem. Because his ptoblem is different. Just write your answers on topic to get upvotes. That's damn easy.

Brian H · Accepted Answer · 2010-12-12 14:37:58Z

0

Improper SQL syntax.

INSERT INTO table (col1, col2) VALUES (val1, val2)

answered Dec 12, 2010 at 14:37

Brian H

8331 gold badge5 silver badges12 bronze badges

1 Comment

acctman Over a year ago

i use to do it that way, but it gets way to confusing when inserting a lot of field entries.

Bojangles · Accepted Answer · 2010-12-12 14:36:18Z

-1

date() arguments need to be a string. Try surrounding your date format strings with single quotes (').

answered Dec 12, 2010 at 14:36

Bojangles

102k50 gold badges175 silver badges209 bronze badges

Collectives™ on Stack Overflow

SQL insert error SQL syntax ... date()

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related