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
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
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
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 =