Re: Storing text with carriage returns in MySQL

Not sure if I understand the issue completely, but if it's a matter of displaying the text from the database you could use the nl2br function. http://us3.php.net/manual/en/function.nl2br.php Hope that helps, Brian on 7/15/04 4:40 PM, Andrew Wood at ajwood@iee.org wrote: > Sorry, its the crap software I'm using to view the DB! > > phpMyadmin shows that yes, the text is all there with CRs. > > so it IS something at the display end? > > any ideas, cos I haven't aclue? > > cheers > AW > > > On 15 Jul 2004, at 21:28, Vail, Warren wrote: > >> Perhaps you have another problem. >> >> Do you have PHPMyAdmin access to the database? Could it be that your >> string >> is being stored OK, and the problem is on the retrieval end? >> >> Warren Vail >> >> >> >> -----Original Message----- >> From: Andrew Wood [mailto:ajwood@iee.org] >> Sent: Thursday, July 15, 2004 1:22 PM >> To: php-gen >> Subject: Re: [PHP] Storing text with carriage returns in MySQL >> >> >> That only seems to work for quotation marks and apostrophes etc. Not >> carriage returns? Unless I'm missing something. >> >> >> On 15 Jul 2004, at 20:23, Vail, Warren wrote: >> >>> http://www.php.net/manual/en/function.addslashes.php >>> >>> Warren Vail >>> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >>