Re: Problem with script

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

 



On Tue, 2004-11-02 at 10:41 -0600, renato.linux@xxxxxxxxxxxxxxxxxxx
wrote:
> Query failed: 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
> 't read card','1099413551')' at line 1

My initial guess is that you do not have magic quotes on.

You might want to validate your data before inserting it into the
database.

Try: http://us2.php.net/manual/en/function.mysql-escape-string.php

Any instances of "'" will break your INSERT query the way you have
it..so you need to insert them all with \' (which escapes the single
quotes)

hth,

Robby

-- 
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON  | www.planetargon.com
* Portland, OR  | robby@xxxxxxxxxxxxxxx
* 503.351.4730  | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
*    --- Now supporting PHP5 ---
****************************************/

Attachment: signature.asc
Description: This is a digitally signed message part


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux