Hi 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@xxxxxxxxxxxxxx> wrote: > -----Original Message----- > From: GuRu [mailto:nagendra802000@xxxxxxxxx] > Sent: 07 June 2013 12:22 PM > To: php-windows@xxxxxxxxxxxxx; php mysql; phpexperts@xxxxxxxxxxxxxxx > Subject: Need help with mysql error > > Hi All, > > 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 > > ('$_POST[date]','$_POST[pt_name]','$_POST[age]','$_POST[od_sph]','$_POST[od_ > > cyl]','$_POST[od_axis]','$_POST[os_sph]','$_POST[os_cyl]','$_POST[os_axis]', > > '$_POST[add]','$_POST[d_sph]','$_POST[od_d]','$_POST[od_n]','$_POST[od1]','$ > _POST[os1]')"; > > 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. > > -- > *Best, > * > *GuRu > CEO & Founder at, > www.myshopads.com > * > ============================== > > Could "add" be a reserved word? Try a different column name and see if you > get the same error. > > Cheers > Arno > > > -- *Best, * *Gu®u CEO & Founder at, www.myshopads.com *
