|
|
Posted by Norman Peelman on 10/13/40 11:34
"cover" <coverlandNOSPAM914@yahoo.com> wrote in message
news:0ugpp11dp93huqrvju6srft6vrv0jsujbh@4ax.com...
> On Mon, 12 Dec 2005 10:20:59 +1300, Chris Hope
> <blackhole@electrictoolbox.com> wrote:
>
>
> >There's a comma before the closing bracket. I would say that's your
> >error. echo mysql_error() after running the query and see what happens.
> >Or alternatively echo out the sql string and paste it into the mysql
> >console or phpMyAdmin etc.
>
> caught the comma after installing the echo mysql_error(); line and now
> have:
> "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 'x 2" x .25', 'no notes')' at line 1" unless I remove the
> measurements from the uhmwsize field which were 60' x 2" x .25"*
>
Mix-matched quotes is what's happening here - the (" double quote) is
signaling php the end of the string and it is truncating the rest of your
query. Like Hilarion said, check out escaping strings -
mysql_real_escape_string() or make sure to read up on magicquotes in your
php.ini file.
http://us3.php.net/manual/en/function.mysql-real-escape-string.php <-
prefered method according to the link below
http://us3.php.net/magic_quotes/
Norm
---
FREE Avatar hosting at www.easyavatar.com
Navigation:
[Reply to this message]
|