MySQL Real Escape String Stops nl2br

[Millar]

Hello,

 

I previously used addslashes on my POST and GET data, I have now changed this to mysql_real_escape_string, as a result, in messages on the site new lines are displayed as nr and do not start a new line.

 

All I changed was the addslashes function and replaced it with MRES.

 

Here is what happens to the data when it is parsed for message display.

 

$text = htmlspecialchars ( $text );
$text = stripslashes ( $text );

[bB CODE PARSING]

$text = nl2br ( $text );

return addslashes ( $text );

 

Also, when I view the data as it was sent to the table in phpMyAdmin, the newlines are displayed (I assume phpMyAdmin runs nl2br on the data it displays on Browse pages.

 

Since I only swapped the addslashes function I do not know why the new lines are no longer parsed. Could it be because of the fact that MRES escapes \n and \r?

 

Thanks in advanced,

Sam Millar.