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...

Recommended Answers

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 ''.

Jump to Post

All 4 Replies

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

Any ideas?

Member Avatar

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

mysql_real_escape_string()

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

Thank you!

Glen..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.