MySQL Forums
Forum List  »  PHP

Re: Error in generated MySQL-syntax
Posted by: Jeroen Smits
Date: December 15, 2016 12:16PM

Thanks for your reply!

If I do it that way, I get another error, and not even the first entry is entered in the database:

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 'VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title',' at line 1INSERT INTO events(StartDatum,StartTijd,EindDatum,EindTijd,Weergavetijd,Titel,Locatie,Beschrijving) VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'),

Could you help me out with that please?

Options: ReplyQuote


Subject
Written By
Posted
December 15, 2016 04:34AM
Re: Error in generated MySQL-syntax
December 15, 2016 12:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.