Need help with mysql error
| From: | Gu®u | Date: | Fri, 07 Jun 2013 10:21:41 +0000 |
| Subject: | Need help with mysql error | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-31010@lists.php.net to get a copy of this message | ||
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,
*
*Gu®u
CEO & Founder at,
www.myshopads.com
*