RE: Need help with mysql error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux