Posted by MS on 10/24/06 10:22

> I have a form where registered users on my site can edit their login
> details. For some reason, the script is inserting an extraneous quote
> mark in the mysql update query that is preventing it from running
> successfully, but I am at a complete loss to understand why.

> This is the error message:
> Error updating details: You have an error in your SQL syntax near
> 'xxxx@xxxx.com' WHERE userid = '15'' at line 4
>

I dont think that the problem is an extra quote, I think the extra quote you
see is the error message within quotes.

'error message' it just so happens that the part of the error it reports
also contains quotes. eg 'the error is '15'' I have had this myself and the
problem has been a field name that was spelt incorrectly.

Check your field names !!

MS

• Next in forum: Re: e-commerce site - need advice
• Prev in forum: strange extra quote mark appearing in mysql query
• Thread view: Re: strange extra quote mark appearing in mysql query

[Reply to this message]