type settings for text

Forum Moderators: open

Message Too Old, No Replies

type settings for text

new to mysql

jyogit

5:34 pm on Jan 18, 2009 (gmt 0)

hi
i have managed to sort out the forms and stuff and i can get all the text into my database.
the last of my inputs needs to be displayed on screen again when needed as sentences and stuff...
when i echo the table data all the text formatting is lost and it all ends up on the same line.

i know i'm probably not explaining this very well...lol

i just want to be able to echo the whole thing as it was typed in.
can anyone help?

coopster

11:58 pm on Jan 18, 2009 (gmt 0)

Sounds like you mean that new lines are not being displayed as newlines, correct? If so, you need to either wrap the data in HTML <pre> tags or change the newlines to <br> elements or use some other method to create the breaks in your text.

jyogit

4:50 am on Jan 19, 2009 (gmt 0)

yes thanks for that
i can do that if i dont just try and echo the text straight out onto teh page but im wanting to ...if possible let the user add her report daily on her page.
send the said text direct to the database and then just simply print the whole thing on a seperate page of hers.
as in like a blogg is what im trying to achieve with as little work as possible... lol
is there not something im missing in the type settings in mysql through phpmyadmin?
all the information is going into the database in the correct order with punctuation etc etc but i cant get it out in the same way.

confused.com...

coopster

3:16 pm on Jan 19, 2009 (gmt 0)

Well you still need to wrap the whole works in your <html> and <body> tags. Either by handling that in your server side code or by writing the FULL html into the table record and read that directly to output.