Using escape_str() or escape() produces a backslash \n character rather than \r\n

[eluser]InsiteFX[/eluser]
If you use Active Record you do not have to worry about this, Active Record will escape everything automatically.

Code:

$sql = "INSERT INTO table (title) VALUES('".$this->db->escape_str($title)."')";

InsiteFX