Retaining line breaks when data comes back out of mysql?

[Quarterbore]

Well, I can describe it better....

I have a Database I am building that serves up information to a Timeshare Resorts Database as in the following link:

http://www.timeshareforums.com/resor...e.php?resort=1

Before I added the nl2br function my text was running on (no line breaks) but as you can see it is all formated now. What I need to do is create a script that will allow me to edit the data as there are too many errors in the data for me to use phpmyadmin to correct them.

The database was actually created using vBaLinks but the vBaLinks program was too limiting for me to use the data as I want so I created a new database with my resort information and now I am trying to flesh out the rest of the tools I need to edit and serve up the data.

Also, does anybody suggest a good MYSQL book? I have a few PHP books but I really need to buy a good MYSQL book to help me get through these issues...

Edit:

Here is a sample page:


http://www.timeshareforums.com/editr...php?resort=300

The code is set such that the value in the RCI Season info comes from this:

PHP Code:

RCI Season Info<br>
                <textarea rows="15" cols="30" name="uprstrciseas" wrap="physical"><?php echo $rstrciseas1 ?></textarea><br />

It is POSTED to my second page as: $uprstrciseas and when you click the "Update" you see that I lose the line breaks...

Note: This is not updating anything in my database as obviously if it were I would have this locked down...

My full output template looks like the following so you can see the data I am working with:

http://www.timeshareforums.com/resor...php?resort=300

When I am done I hope to integrate this into my vB system to asign edit permissions and the like but as of now it is a stand alone application to keep in "simple"

OK, I talked with a SQL developer at work and he gave me a hint that seems to have solved my problems.... To send a $variable and retain the line breaks it is necessary to convert it to html before passing the value via a POST command...

For example:

PHP Code:

$variable = addslashes(htmlspecialchars($_POST['variable])); 


When the value is received, I then need to undo the changes in the posted value using the following code:

PHP Code:

nl2br($_POST['uprstrciseas']); 


Amazing.... I spent hours searching every book I have to figure this out and he spit it out like it was common knowledge

This was a major victory but it is rather anti-climatic that two lines of code that are that short were all I needed... Now I can work on programing the rest of my page... WOW!