Help with MySQL - PHP

[siu]

I have a problem, I have a text field which I enter text information where I put the following information as an example:

1.) This is good
2.) This looks good
3.) This ought to be good

:mad: The problem is that when I query the MySQL table and echo the record, it displays me like this:

1.) This is good 2.) This looks good 3.) This ought to be good

:eek: But when I display it on a text area of a form it goes correct, but with php, using echo, print, etc... doesn't help me at all. I would appreciate any kind of help.

[xblue]

Hi,

what php outputs is usually html.

and in html line-breaks simply don't have much effect (unless displayed within a textarea), you need html tags <p> or <br> instead.

luckily, there's a function called nl2br() to do the conversion for you 😉

hope I got you right...
xblue

[siu]

Thanks for your response, I will be trying this in the night. If it solved my problem I shall notify you in this forum. Thanks again! Bye! 🙂

[siu]

It worked! Thanx pal. I still have a problem though, hope you can give a hand or anyone that reads this. The problem is when I use a tab or spaces (more than 1), is there any other function that helps me in this case?

example:

INSIDE THE TEXT FIELD

  I have a 5 space margin because this is the first line of the paragraph, and I haven't done this well in html, hope someone can help me out here if there is some way to solve this problem with php.

WHEN I ECHO:

I have a 5 space margin because this is the first line of the paragraph, and I haven't done this well in html, hope someone can help me out here if there is some way to solve this problem with php.

It displays me like if it didn't existed the 5 spaces. Anyone please? I'll appreciate any response.

[xblue]

html basics, too 😉

the browser treats a sequence of spaces (or tabs) as one or skips them alltogether at the beginning of a line.
This makes some sense as it allows indentation and makes the html source code easier to read.

If you want the html output to show indentation, you'd have to convert spaces to no-break spaces, e.g.:

str_replace(' ', '&amp;nbsp;', $string);

There is one drawback with this:
If you have very long entries, the browsers can't wrap lines automatically, just the way it is here in the forum:

echo "     This is going to be a very long string with five spaces at the beginning. The spaces are displayed properly but now you will need a new monitor with a really high resolution to read this without scrolling all the time.";

[siu]

Thanks for the recomendation, I will be taking it in consideration.