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