PHP/MYSQL table problems

[Anon]

Hi I have the following table (real simple):
CREATE TABLE txttest (comments TEXT);

I then use a <textarea> to type in my comment..
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)
BUT
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

ANY IDEAS??

Thanks
Mike

[Anon]

Maybe whoever told you to urlencode knows something I don't, but I don't know why you would.
I would usually use addslashes($comments) so that you won't have problems with apostrohpes. I would guess that the % is giving you problems.
I'm new at this, though. Hope it helps anyway. <g>

Anna

[Anon]

I think the "," maybe have special defination

Because the php is same to the unix shell!!

Reading some books about shell maybe helpful