text from database not displaying properly

[ko_cjun]

hello everyone!

i'm trying to display a text from my database, that part is already fine but when the value of the text has a - or ' (maybe there's more) in it, instead of displaying the actual - or ' it displays other special char like smileys and stuff.

so ahmm how do i fix this?

i'm using nl2br before placing it to the database btw...

THX!

[R0bb0b]

hello everyone!

i'm trying to display a text from my database, that part is already fine but when the value of the text has a - or ' (maybe there's more) in it, instead of displaying the actual - or ' it displays other special char like smileys and stuff.

so ahmm how do i fix this?

i'm using nl2br before placing it to the database btw...

THX!

You should probably try it on another computer to make sure it is not some type of spyware.

[Manuz]

whether u r inserting values into the table manually or through the code

[cadillacwd]

You need to back slash those charachters before they are stored in the database.

Do a search for maqic quotes in php or mysql there a couple of them out there that will do the job. I am at work otherwise I will send you the one I use.

[cadillacwd]

You need to back slash those charachters before they are stored in the database.

Do a search for maqic quotes in php or mysql there a couple of them out there that will do the job. I am at work otherwise I will send you the one I use.

//Create a function for escaping the data 
function escape_data ($data) {
		global $dbc; //need the connection.
		if ('get_magic_quotes_gpc'){
		$data = stripslashes($data);
		}
		$data = trim($data);
		return mysql_real_escape_string($data, $dbc);
		}// End Function