从数据库中使用auto 进行回显

Question

Hey I have on my database a text with 800 chracters when I echo it out it display in just one line getting too big and bad for read,

echo mysql_result(mysql_query("SELECT `message` FROM `pm` WHERE `pm_id` = '1'"));

How do I put
or automatic on the end of every line because there is differents datas inserted in the database and do manualy for every one is hard.

edit: I want to meke it like: one after 100 characters or something like that.

Answer 1

Use the wordwrap function: http://www.php.net/manual/en/function.wordwrap.php

echo wordwrap($data, 100, "
"); // Or use "<br/>" in html

There also is a 4. parameter. If you data does not contain any spaces, wordwrap can not break between words. If you set the 4. parameter to true, wordwrap will cut no matter if within a word or not.

// cut after 100, no matter if inside a word.
echo wordwrap($data, 100, "
", true);