How do I convert return linefeeds in \r\n?

[marms]

I am using someone's script to do a MySql dump of my database since I can't use phpMyAdmin due to a strange web hosting situation I am in.

The problem I have is that this guy's script does not put "\r\n" in for the return linefeeds like phpMyAdmin does and makes the dump file 4meg larger than it needs to be due to all the line breaks in the large "text" fields users enter notes into.

How do convert those return linefeeds into \r\n using a PHP function? I don't know what to reference since they are like hidden charaters or something in the database fields.

Thanks

[bastien]

[man]nl2br()[/man]

[marms]

The nl2br() function is to convert \r\n into HTML <br> tags right?

That is not what I am looking for if it is. I need to turn all that whitespace and linebreaks produced from a user entering text into a textarea field into \r\n

This dump script produces fields in the INSERT statement it creates like so:

','Hello this is and example note
and here is a line break
and another one
', ' another data field','

I need it to look like this:
','Hello this is and example note\r\nand here is a line break\r\nand another one\r\n', ' another data field','

So the statment comes out on one line

Does anyone know how to do this?

[leatherback]

hi,

If I am correct, these values ARE in the text.

When I process userinput, where I do not want linebreaks, this is what I do to the input-variables:

function removelinebreaks($intext)
  {
  $uittext = str_replace("\r\n", "", $intext);
  return $uittext;
  }