Mysql insert seems to be compact?

[Anon]

Hi there,

I have a basic messaging system that allows users to communicate on my site. The user types in the message, and maybe includes newlines/paragraphs. However, in mysql, it ignores the new lines, and i want them to stay there! Anyone know how to get this working correctly?

Jonathan

[[deleted]]

MySQL does nit ignore the newlines.

Newlines are not 'rendered' by HTML, use nl2br() to replace the newlines with the BR tag.

[Anon]

Hey Vincent do not forget:::

$replace = str_replace("\n","<br>",$place_variable_here);

It might not be ethical. It doees work though! 🙂
Ziggs