[futurejp]

Hey.

I have a little form on a website where a person enters his/her name in one box, posts text in the second, and presses submit. Then the page refreshes, this data is entered into a table in my database, and then the data is retrieved back and posted on the page. Here's the problem.

Say the text the person entered in is:


"Hi! I know these composers:

Bach
Mozart

and these bands:

The Rolling Stones
Phish"


This text is inserted into my table this way, but when I retrieve it and post it, all text formatting is gone. So it looks like:

"Hi! I know these composers:Bach Mozart and these bands: The Rolling Stones Phish"

Or something like that. Essentially, extra spaces, line breaks, and things like that aren't kept. How can I fix this? Is it just as simple as changing the Field Type in my table? Right now, the type is just 'TEXT.' Or if not, what can I do?

Thanks

[futurejp]

Actually, solved it myself. Just put the retrieved text in <pre></pre> tags, and set the font of that stuff to match the rest of my page. Thanks anyway

[futurejp]

Actually, I still have a problem, and I'm wondering if anybody could help. Take a look at this page of my website, it has an example of this form:
http://vindaloo.web44.net/tour.php?d...84&t=2&tour=23

If you post a review or comments, the page will refresh and you'll see them. Here's my question.

The main contents of that page, namely the Date, Location, Venue, Support, Setlist, Notes, and Reviews section are all in a 2-column table. The table width is 700px, I think. I set the width of the left column to be 14% of the total. For the couple elements in left columns that are wider (such as the light-blue "----------------------------------" that you'll see) I tell it that colspan=2. Fine, it works.

And, per my above posts, now if you post a review and use line breaks and things like that, they will stay there. But here's the problem. If you DON'T use line breaks, and you type a lot, your whole comment will just stay on one line, and for some reason, it will dramatically increase the width of my table. For example, if you typed this as a review:

"Words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words words " etc, then it won't recognize a table boundary and cut to a new line. Rather, the table extends itself to the right, therefore also increasing the width of the left-column (because it's just 14% of whatever the total width is) and just giving the page a horizontal scrollbar which I hate.

How can I make it so that when the contents of a review reach the end of the 700px table, it essentially uses 'word wrap'? You can see in the Notes: section on that same page that this happens there. The text "these notes are for debugging" were all printed on one line, and when it reaches the end of the table, it wraps around.

Any ideas?

Thanks

[Tarman]

I beleive I got a good work around for it but not sure it is what you will want to do. You must put a table within a table. Set the outside table to a fixed length VIA Pixels not %. Then on your internal table leave the length blank and the internal table will adjust to the correct text size without pushing out past your other table. This will allow all your inner parts of the table to auto adjust and it will word wrap if need be.

If they ever stop reveiwing my website for approprate data you can see what I am talking about by going here. http://ddoitems.net63.net/

If you need to see the coding I can post it later for you I just need to head off to my real life job...LOL

[Mr.Whisper]

php has a function for this problem

just use nl2br($string);

this will replace new line with <br>

[futurejp]

Oh, great. What I actually did was the same thing, just a bit longer:

str_replace(chr(13).chr(10), '<br>', $r);

Thanks though!

[geshan]

YOu might also want to use stripslashes() function of php.