submit form and mySQL

[Anon]

Hi, I am having problems entering data into a mySQL database as follows:

I am submitting text data from a basic html form with php. This works fine except if some of the text data in the form has been cut and pasted from a web page. In this case the data appears to have been inserted into the database, but when I check my tables its not there.

Is this text somehow corrupted, and if so is there a way to 'clean it'.

Thanks,

Kenny

[craigh]

try urlencode() the variable before you throw it in the DB

http://www.php.net/manual/en/function.urlencode.php

[[deleted]]

In what way is it corrupted?

[Anon]

I am not sure if it is corrupted, what seems to happen is this.

If I type text directly into my form it gets entered into the db just fine.

If I copy and paste text from a web page into the form, I dont get an error but the data does not go into the db.

My form data is entered directly into the db (no validation) maybe this is my problem?

Kenny