Memo multi lines replacement of 13 10 to \r\n

[medaps]

Hi,
How do I save multi lines to a mysql memo field replacing char 13 char 10
to '\r\n' instead ?. Example the memo is saved as 'string1<13><10 >string2'
instead of 'string1\r\nstr ing2'

The reason behind is to populate the mysql memo field to a html form field using a php module called from html as this:

<?
$s=trim($wg['MYSQL_MEMOFIEL D]);
echo "<script language='javas cript'>window.p arent.document. all['memo_fld'].innerText=".$s .";</script>";
?>

javascript aborts: unterminated string constant.

Is there is a better way to do the same please let me know. This code is called from a form button to fetch a table record.

Thanks in advanced.

[ronverdonk]

In PHP you can replace strings using e.g. the preg_replace or the str_replace functions.

str_replace
(PHP 4, PHP 5)

str_replace — Replace all occurrences of the search string with the replacement string

Description
mixed str_replace ( mixed $search, mixed $replace, mixed $subject [, int &$count] )

This function returns a string or an array with all occurrences of search in subject replaced with the given replace value. If you don't need fancy replacing rules (like regular expressions), you should always use this function instead of ereg_replace() or preg_replace().

As of PHP 4.0.5, every parameter in str_replace() can be an array.

In this case it is easier (to code) the str_replace() to get what you want. So to replace the '13' and '10' literals you can use the following command:

[php]$output_string = str_replace(arr ay("13", "10"), array("\n", "\r"), $input_string);[/php]
Ronald :cool:

[medaps]

Thanks again.
It worked
Jose