mySQL line breaks

Galavantes

So how do I create a field in mySQL that will recognize line breaks?

bogu

Type text ...

Galavantes

No, because to mySQL
INSERT IN mail (mailID, senderID, recipientID, time, content) VALUES (NULL, '1', '1', '1', 'Dear Whoever,
blah blah blah')

Is the same as:
INSERT IN mail (mailID, senderID, recipientID, time, content) VALUES (NULL, '1', '1', '1', 'Dear Whoever, blah blah blah')

bogu

Prove it ...

cgraz

you may want to use nl2br() when outputting your fields to ensure your newlines are being shown as line breaks. Otherwise, just print as is, then look in your source to see if the line breaks are there. Your source will put line breaks on new lines, but in html, the line breaks mean nothing.... you need to use <br />