It seems that mysql_escape_string and mysql_real_escape_string do undesirable things to EOL markers - data from textareas escaped with either of those functions is entered, and retrieved with, the characters /r/n instead of a true line break.
This snippet of code demonstrates the problem: <?php $wibble = "\"This\" and\n'that'"; echo "Before: $wibble<BR>\n"; $wibble1 = addslashes($wibble); echo "Addslashes: $wibble1<BR>\n"; $wibble2 = mysql_escape_string($wibble); echo "Escape: $wibble2<BR>\n"; ?> And the output (from Show source) with line breaks exactly as in the source Before: "This" and 'that'<BR> Addslashes: \"This\" and \'that\'<BR> Escape: \"This\" and\n\'that\'<BR> Is this a bug, or am I totally missing something? Cheers -- David Robley Useless Invention: Avalanche prevention goggles. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
