• 0

[PHP] Problems with quotes after moving database


Question

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.

Thank you in advance.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.