PHP/MYSQL table problems

[bvrtrimmer]

Hi I have the following table (real simple): <br><br>CREATE TABLE txttest (comments TEXT); <br><br>I then use a &lt;textarea&gt; to type in my comment.<br>This text then gets inserted into the table above. <br><br>I was told to use: <br>$comments=urlencode($comments); <br>before inserting into my database<br>&nbsp;<br>This WORKS when I type in something like: <br>&quot;this is a comment line&quot; <br>(looks like: this+is+a+comment+line)<br>&nbsp;<br>BUT if I type in something like: <br>&quot;this is a comment line, <br>this is another comment line&quot;<br>&nbsp;<br>(looks like: this+is+a+comment+line%2C%0D%0Athis+is+another+comment+line) <br><br>I get this error: <br>Error in executing INSERT INTO txttest (comments)<br>VALUES('this+is+a+comment+line%2C%0D%0Athis+is+another+comment+line') <br>error:1065 Query was empty <br><br>ANY IDEAS?? <br><br>Thanks <br>Mike

 

[rycamor]

I believe when you urlencode, you also need to use addslashes($encoded_data) before entering into database.