apostrophe char problem

[Halid Faith]

Hello

I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53  on
FreeBSD5.3

I add any text as data with phpadmin on web. it works well. But I have a
problem.
As example if I add a text to mysql table with phpadmin.
My text contains as below;
"Halid 's car is expensive"

I will see above the sentence as "Halid ''s car is expensive" on web
(internet explorer)
That is, I see that double ' apostrophe character out

What shall I do ?

Thanks