problem with copying a record and insert in the same table

mistercash60000

well I have moviedatabase
and of each movie I have a description column( type=text). some are 200chars and other 800chars.
I want to be able to copy this movie in the same table. My primary key is an auto_increment.

First I get the data for that movie that is been chosen by an sqlquery.
Then when I get the data I insert that data to variables
like: $settitle, $setdescription

Then after that I do an insert query
like: insert into tblmovies (Title, Description) values('$settitle','$setdescription').

Now comes the problem when the description of the movie is less then 500chars he inserts the movie, but if it's larger then 500chars he says this:
You have an error in your SQL syntax near 's desperation for romance turns into a convoluted scheme to match Kat with her m' at line 1 at this her m'==>that is the 500th char.

The variable contains the whole description because I have printed it before the insert and there he shows all the chars even if it's more then 500 chars.

ps:I have insert the whole table with phpmyadmin and there he didn't say anything of problems.

Does somebody know why this is happening?
Is there maybe an limit on chars or something?

tserbis

mysql_escape_string ?

mistercash60000

So why does my php thing doesn't work

And what do I have to do with mysql_escape_string?
should this solve the thing?

A little update: I have also another page that is used to add movies.
Well there I have no problem with adding a description of 500chars or more. There I have used the same insert query.

Weird isn't it?

tserbis

I mean
have your "problem movie description" a single quote?

Use
INSERT ... ' " . mysql_escape_string($setdescription) . " ')

mistercash60000

I have used that mysql_escape_string($filedata));
but it seems that it is not solved, gives the same error.

Do you know why this is happening and not at my addmovie page, there I use the same sql statement

tserbis

Show me (copy/paste) lines with mysql_query that produce your error, error text again and $setdescription content at that moment.