You are here: Re: Field Number Limitation into MySQL « All PHP « IT news, forums, messages
Re: Field Number Limitation into MySQL

Posted by Norman Peelman on 10/06/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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация