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
(I've also been told to use addslashes(), that did not help)

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

(I've also left out the comma in the comment line above as well, same thing)

ANY IDEAS??

I've posted this on about 4 different sites and still no solid answer.

Thanks

Mike

Anon

Your problem is % is a wildcard and needs to be escaped.

I prefer to leave magic_quotes off and magic_quotes_gpc on, therefor, when a user posts (or gets) a string, is is already slashed and ready to be put in the db.

<? if ($submit) {
$db->query("insert into table txttest (comments) values ('$text')");
header ("location: someotherpage.html");
exit();
}

Anon

Hi Long lost brother.
I'm facing a similar one with more cols,
amongst a host of others.
Life is so uncool.
Seems I'll get an answer today from a
resident Swamy here
Brgds Relax,
Raj