Re: Need help with mysql error

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" <[email protected]>
To: <[email protected]>; "php mysql"
<[email protected]>; <[email protected]>
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
*


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