php/mysql problem(question)
 

i have ' character in my database, but when i make a select and display the content with echo() the ' character is auto replace with ? character..
what i have do to stop this auto replace?

That's kinda bizarre...does your page have a character set selected?

[HTML]<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />[/HTML]

If that's not it, try inserting it into the database with the function addslashes:
Lastly, if that doesn't work, make sure you're using the standard ascii ' symbol and not some strange variation like word puts in...

i don't have that HTML code on my pages.. and when i've entered the text to the database i used addslashes() function.. now when i select the text from database, i use stripslashes() and echo($text) and instead ' character i get ?

anybody else know what can be?

What browser are you using and what character(s) is displaying as ?
?
Have you tried converting symbols to their html counterpart before entering them in the database using htmlentities() ?

For eg, the Euro symbol, depending on the encoding text will displaying incorrectly on Firefox, but will do fine when 'encoded' using htmlentities() for storing.

Sounds like a character set problem either in the page/server or your browser.