July 31st, 2000, 05:23 PM
Hi I have the following table (real simple):
CREATE TABLE txttest (comments TEXT);
I then use a <textarea> to enter text.
This text then gets inserted into the table above.
I was told to use: $comments=urlencode($comments);
before inserting into my database
This WORKS when I type in something like:
"this is a comment line" (looks like: this+is+a+comment+line)
if I type in something like:
"this is a comment line,
this is another comment line"
(looks like: this+is+a+comment+line%2C%0D%0Athis+is+another+comment+line)
I get this error:
Error in executing INSERT INTO txttest (comments)VALUES('this+is+a+comment+line%2C%0D%0Athis+is+another+comment+line')
error:1065 Query was empty