15665Re: [PHP-WIN] Need help with mysql error
- Jun 7, 2013Hi All,Yes 'add' is a reserved word & that was my mistake. I was looking it from PHP side all the time. I didn't thought about MYSQL stuff. I have changed it to 'os_add' and now its working. Thanks guys. You guys rock :)
On Fri, Jun 7, 2013 at 8:47 PM, Arno Kuhl <arno@...> wrote:-----Original Message-----
From: GuRu [mailto:nagendra802000@...]
Sent: 07 June 2013 12:22 PM
To: php-windows@...; php mysql; email@example.com*Best,Subject: [PHP-WIN] Need help with mysql error
I am working a a project in which there is a table with some variables. I
have a form with which I pull the filled data by user and want to put into
mysql dtabase. Below is my query.
$sql="INSERT INTO recipt (date, pt_name, age, od_sph, od_cyl, od_axis,
os_sph, os_cyl, os_axis, add, d_sph, od_d, od_n, od1, os1) VALUES
However I am getting an error saying:
Error: 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
'add, d_sph, od_d, od_n, od1, os1) VALUES ('12-12-2013','guru
prasad','23','12'' at line 1
I have tried gooling it but no luck. Please help me with this error.
Thank you in advance.
*GuRuCEO & Founder at,*
Could "add" be a reserved word? Try a different column name and see if you
get the same error.
CEO & Founder at,
- Next post in topic >>