Re: Variable stores incomplete values...

Your question encompasses two parts... the subject says these variables are storing incomplete values and later in the email you state mySQL isn't maintaining the formatting of your data. The first part is possible because your mySQL database field may not be declared big enough to actually hold the data. AFAIK there is no limit on actual variable size, as long as the server has enough memory, it should be fine. Your second question about formatting... well the answer is the formatting is most likely in the database, but when you retrieve it and siaplay it ina browser, well the browser doesn't understand anything other than HTML. So carriage returns, line feeds, tabs, etc... never get displayed. If you want the formatting to be kept in the browser, convert the data. A good starting place is nl2br() At 02:22 AM 2/19/01 -0600, Richard Lynch wrote:

$variable = This is the data.This is the data.This is the data.This is the dataThis is the dataThis is the dataThis is the dataThis is the dataThis is the dataThis is the dataThis is the data This is the dataThis is the dataThis is the data This is the; da;taThi's is the dataThis is the dataThis is the data This is the dataThis is the dataThis is the dataThis is the data I mean to say taht it is kidof formatted with REturn character, space characters, ', ; and a lot many characters... Now my question is that. If I store the variable in MYSQL dataabse under a particular filed TYPe varchar or TEXT. It doesn't bring up the same kind of format like it was when it was stored.. Is there any way I can get the same output like I stored it.? Use http://php.net/addslashes maybe... If it's varchar(XX) and your string is longer than XX, you will lose the end of the string. If you're not sure how long it might be, just use TEXT in MySQL. -- Visit the Zend Store at http://www.zend.com/store/ Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net