| Russell Johnson 2004-11-02, 3:55 pm |
| Just looking at the error message shows why it's failing in this case: =
"'t read card','1099413551')' at line 1" One of the fields you're trying =
to insert is likely 'Can't read card', and since in the query you are =
surrounding it with single quotes, and it's coughing on the word Can't , =
which has a single quote.
Check out the add_slashes($str) function, which will add a backslash =
before the single quote, e.g., 'Can't read card'. That should do the =
trick.
- Russ
-----Mensaje original-----
De: renato.linux@desertcomputers.com
[mailto:renato.linux@desertcomputers.com]
Enviado el: Tuesday, November 02, 2004 5:42 PM
Para: php-db@lists.php.net
Asunto: [PHP-DB] Problem with script
Hi all, greetings from Phoenix, Arizona!
I'm having a problem with a PHP script and the database it manages.
I'm having his error message:
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
I don't know what is happening, usually the database works well but
sometimes this strange error appears. I'm sending you the scripts in =
where
I think the error could be.
Any suggestion or comment will be very appreciated.
Thanks
Renato
|