[SOLVED] mysql_real_escape_string

[seb hughes]

When i use this it makes you're become you\'re. When i pull the data from the database how do i get it to go back to you're?

[marcus]

The function mysql_real_escape_string, will escape all apostrophes, making the input value more secure.

 

To retrieve the data back to its normal state use stripslashes.

 

<?php
$sql = "SELECT * FROM myTable";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);
$msg = stripslashes($row[message]);
echo "Message: $msg";
?>