Text Field in database

Poofman

I'm working with a premade database from a program that uses it. There is a text field called player names in the database. When I view the database through my host admin, the field holds the following.

Player1
Player2
Player3

etc.

But when I load this field into an array or string, it puts them all together like this:

Player1Player2Player3....etc.

How can I load them into an array so that there is a carriage return after each one, so when I print it they are like above.

Player1
Player2
Player3

etc. How do I get my code to recognize the return after each one?

Poofman

Ok, I figured part of that out, and ran into a new problem. Here's the code, and what happens. Note: I have to use imap_base64 because the text is encoded in the text field.

If I use this:

  $enames = $a_row->player_names;
  $player_names = str_replace("\n", "<br>", $enames);
  $tnames = imap_base64($player_names);

it does insert the <br> in so each name is on a different line for output, but the third line won't unencode them once this is done, $tnames comes up blank.

If I use this:

  $enames = imap_base64($a_row->player_names);
  $player_names = str_replace("\n", "<br>", $enames);

the unencode must strip the \n because it unencodes them, but doesn't separate them, so I'm back to Player1Player2Player3 etc.

Poofman

Nevermind, figured it out. I exploded the field into an array, then used a loop to convert each name in the array.

Pig

You might want to check out nl2br() as well.