Click here to Skip to main content
14,931,892 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
in phpmyadmin i am executing this sql statement which is constructed in php on my website
<pre>INSERT INTO guv0l_seminarregistrations_2020 VALUES('No'","2021-05-10","2021-05-10 13:10:51",'20210510131051bmoj','1','Danny Whiting','9024423683','','danny_whiting@hotmail.com','NSHA','','','131 Shrewsbury Road','','Dartmouth','NS','B2V2R6','','','','','','250.00',"37.50","'15%','Cheque/PO/Money Order','PPOOP','287.50','0.00','0.00','0.00','0.00','287.50','No',"Active",'Regular','No','','ootvffiqyz','')


but it gives me this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2021-05-10","2021-05-10 13:10:51",'20210510131051bmoj','1','Danny Whiting','9...' at line 1


i cannot find an error i have checked db table for proper data types.

can someone fin d a roblem and suggest a solution

thanks in advance


What I have tried:

i tried double and single quotes and verified all table fields data types
Posted
Updated 10-May-21 8:20am

1 solution

Look closely at the error message:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2021-05-10","2021-05-10 13:10:51",'20210510131051bmoj','1','Danny Whiting','9...' at line 1

Now look at what you typed, paying close attention to the string delimiters:
SQL
VALUES('No'","2021-05-10","2021-05-10 13:10:51",'20210510131051bmoj',

Are you sure that '"," and "," and ",' are correct?
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900