Don't Display Escape Characters

[codeline]

I've got a basic text input area within a form for users to add a brief bio about themselves. I made sure to use mysql_real_escape_string to avoid problems with special characters. However, when I want to display the content within the text area when a user chooses to update or change their bio, the text displays the escape characters.

 

How do I display data from my db without the user having to deal with the escape characters?

[ngreenwood6]

Very easy:

 

$string = mysql_real_escape_string("Test's with data's");
echo stripslashes($string);

[MadTechie]

Check to see if magic quotes are on, they probably are, if so turn them off or strip the slashes BEFORE entering it into the database

 

here is some portable code from php.net

<?php
if (get_magic_quotes_gpc()) {
    $lastname = stripslashes($_POST['lastname']);
}
else {
    $lastname = $_POST['lastname'];
}
$lastname = mysql_real_escape_string($lastname);
$sql = "INSERT INTO lastnames (lastname) VALUES ('$lastname')";
?>

[codeline]

Thanks, guys!