Format MySQL info?

[CrazeD]

Is there a way to make the contents of my MySQL table the same as the way it went in?

 

For example, if I insert:

1

2

3

4

5

6

into my MySQL table, it comes back out as:

1 2 3 4 5 6

 

Is there a way to fix that?

 

My field type is TEXT, if that matters.

 

Thanks.

[shortj75]

i had the same problem i fixed it by adding a break <br> after my query like this

$getnum=mysql_query("SELECT * from yourtable");
    while($getnum2=mysql_fetch_array($getnum)){
echo "$getmun2[tablerow]<br>";
}

[CrazeD]

No, I'm not talking spacing between each row.

 

Like say you have a textarea, and you enter:

"blah blah blah

blah

blah blah

blah blah blah blah"

 

It goes into the MySQL table like this:

"blah blah blah blah blah blah blah blah blah blah"

 

Is there any way to change that?

[Yesideez]

echo nl2br($getnum2[tablerow]);

 

Like that?

[CrazeD]

No no no, you're not listening.

 

It goes into the table as a one-line string, it doesn't have breaks in it.

[wildteen88]

How are you inserting it into your database table? Post the relevant parts of your code here.

 

If you enter

line1
line2
another line
b
l
a
h

It should go into the database as you have typed it.

 

However when you get the data back out of the database and display it in the browser you may find it displays as this:

line1line2another lineblah

This is nothing to do with PHP or MySQL but the browser itself. Web browsers ignore most whitespace characters (\n, \r, etc). In order for the browser to display your textareas you have entered it in the textarea you will need to use the html equivalent, eg <br /> for newlines.

[per1os]

No no no, you're not listening.

 

It goes into the table as a one-line string, it doesn't have breaks in it.

 

I think you are the one not listening.

 

Anytime you enter data into a DB from a textarea it has \n characters or new line characters. www.php.net/nl2br converts the \n to < br />  so it is visible by the webbrowser.

 

I bet if you viewed the source of the data currently printed it would look like it did when you entered it into the DB.

 

Give it a try and see what happens.