Unanswered: Problems with quotes after moving database
Hi to all,
I moved a db from a website to another but i have big trouble with single/double quotes. I've recreated the site and built a new database with the same name as the original database. When I try to update an old article on the website I get the following error..
I'm givin' her all she's got, Captain, but we need more power!
This error said :
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 've seen and manage your video collection.', `DESCRIPTION` = 'Coollector is a gre' at line 1
And this because the description of the article contains a single quote:
Coollector Movie Database: track the movies you've seen and manage your video collection.
The old website MySQL version: 5.0.81
The new website MySQL version: 5.1.30
Pls. help me with a simple soution, it's been two days since i try and i try and I'm going crazy.