Syntax Error

[lovemycrafts]

I am having the same problem! (See below @ <snip>)

UPDATE members_data SET descr='Empower your child\\'s mind with books & software that develop critical thinking across the curriculum! ' WHERE listname="lovemycrafts" AND id=110
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 's mind with books & software that develop critical thinking acr

How do I fix this?



<Snip>

I have a couple members who are trying to change there listings ... when I click approve I get this message back:

UPDATE members_data SET name='Pamm's House' WHERE listname="earlychildhood" AND id=103
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 's House' WHERE listname="earlychildhood" AND id=103' at line 1

What does this mean?

[Scott]

Hmmm... interesting. It looks like this is happening because of the ' in the description. I thought we had this problem fixed but I guess not. I will do my best to get ahold of the programmer to fix it this weekend but if not, monday for sure.

In the meantime, I have taken the apostophe out of the word child's that is causing the problem and you can make changes now.

I'll post here when the problem is solved more permanently.

[lovemycrafts]

Thank you very much for your quick response and the temporary fix!!

Carla

[Scott]

All fixed now! Feel free to add as many apostrophe's as you'd like!

[lovemycrafts]

Thank you very much! You're a peach!