Text rstops query working

[GlenRogers]

Hi, I have this query to add data to mysql

$query = "INSERT INTO products VALUES('', '$acode', '$aname', '$acontent', '$aprice', '$remote_file', '$cat')";

My table is
id int(20) primary ai
code varchar(200)
product_name varch(200)
description varchar(600)
price decimal(10, 2)
imagepath varchar(200)
product_id int(10)

I have an html textarea to enter data for the description field. When the text in the textarea is, say, 250characterslong, everything is fine-the query works and all data is added to mysql. But when the text is say 500 long the the query does not work and nothing is added.

Can anyone help?

Thanks for looking

Glen...

[diafol]

varchar can only go to 255, depending on the version of MySQL. Try setting datatype to text, to see if it helps.

http://dev.mysql.com/doc/refman/5.0/en/char.html

Also, set the first field to NULL not ''.

[GlenRogers]

Thats still not working. It adds nothing. But if the text description is short the it adds to the database ok.

Any ideas?

[diafol]

OK, could it be due to unescaped characters? You're using mysql_real_escape_string() right?

[GlenRogers]

mysql_real_escape_string()

I wasnt using this, but using it now has sorted the problem!

Thank you!

Glen..