a bug in my program (MySQL/PHP)

I have written a dicussion board program.
Indeed,this is my first PHP/MySQL program.
I found a bug that I have no idea how to solve it.

If a user entered a message with a ' in it,
the MySQL will prompt a error message.

I am using a <textarea></textarea> in HTML

my program can be reach at http://www.hkccm.com/msgboard/easyphpboard.phtml
the speed maybe slow, since I am using a 9 bucks/month webhosting service.

You need to addslashes() to the text before inserting.

$text=addslashes($text);

Thanks Rod!
it works!
hehe

also thanks for your Next/Prev buttons code in PHPBuilder.com

ahhh, my code got another problem.....

if I input:
---------------
This is a Test
This is a Test
---------------

the output will be:
-----------------------------
This is a TestThis is a Test
-----------------------------

is there a PHP function for displaying the string correctly?

If you output it as HTML it will do that just as if you typed that in your HTML code (returns not displayed).

You can use the HTML <PRE> tag or you can use PHP's nl2br() function which converts new lines to <br>s