Re: [PHP-WIN] Need help with mysql error

2013-06-07 Thread Gu®u
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 wrote: > -Original Messa

RE: [PHP-WIN] Need help with mysql error

2013-06-07 Thread Arno Kuhl
-Original Message- From: GuRu [mailto:nagendra802...@gmail.com] Sent: 07 June 2013 12:22 PM To: php-windows@lists.php.net; php mysql; phpexpe...@yahoogroups.com Subject: [PHP-WIN] Need help with mysql error Hi All, I am working a a project in which there is a table with some variables. I

Re: [PHP-WIN] Need help with mysql error

2013-06-07 Thread Jacob Kruger
What's the sort of final result version of $sql look like? I am assuming that you're using something like sprintf function to build it up based on original string, and values, etc.? As in, I myself would generally have used something like $sql = sprintf("insert into %s...", $tableName); etc. -

[PHP-WIN] Need help with mysql error

2013-06-07 Thread Gu®u
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