RE: [PHP-DB] Problem with script

2004-11-02 Thread Bastien Koert
from the brief error message your provided, I think its blowing up on the single quote contained in the word can't. you need to handle this by choosing one a few of these methods replace all single quotes with two single quotes $text = str_replace(','', $text); addslashes function $text =

Re: [PHP-DB] Problem with script

2004-11-02 Thread Robby Russell
On Tue, 2004-11-02 at 10:41 -0600, [EMAIL PROTECTED] 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

RE: [PHP-DB] Problem with script

2004-11-02 Thread Russell Johnson
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

RE: [PHP-DB] Problem with script

2004-11-02 Thread Peter Lovatt
Try echoing the actual query being run. It will give you more info to work with. Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 November 2004 16:42 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with script Hi all, greetings from