Re: Need help with mysql error

From: Date: Fri, 07 Jun 2013 12:07:35 +0000
Subject: Re: Need help with mysql error
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-31011@lists.php.net to get a copy of this message
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. - and that's a bastardised version to give you a better idea, and, the easiest way to maybe try find out exactly what's causing the issue would be to echo/spit out the whole $sql string value instead of trying to execute it for now, followed by exit; or something like that to just see what the resulting T-SQL statement would have been/contained. That also brings up that when I insert/make use of form field values in building an SQL statement, I would want to make sure they get processed by mysqli_real_escape_string function - partly since I prefer using mysqli, instead of just mysql, to make sure there are no funny characters in the values as such. The standard mysql real escape function is explained here: http://php.net/manual/en/function.mysql-real-escape-string.php Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...' ----- Original Message ----- From: "Gu®u" <nagendra802000@gmail.com> To: <php-windows@lists.php.net>; "php mysql" <PHP_MySQL_usergroup@yahoogroups.com>; <phpexperts@yahoogroups.com> Sent: Friday, June 07, 2013 12:21 PM 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 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 *

« previous php.windows (#31011) next »