Text from MySql to an HTML table

[sdm]

This is my problem.

I have a file called michellecoy.txt which is formatted text in the root folder, I want to display this text in an HTML table on a web page. In the Database I have a 'VARCHAR' field with the text michellecoy.txt in it, what syntax do I need to display this file within the table on the webpage ?

Or would it be easier to have this text within a field with the type 'TEXT' ? If this is better then how do I display it to stop it all coming out on one line ?

Please help as I can't progress any further until I have sussed it.

[br__ken]

text sql fields should accept line breaks and that type of stuff- so just print it out normally. if thats not working ill try to help more

[irishprogrammin]

try nl2br() when reading the data back out into your html table, that should pick up the line breaks and format it correctly