#1
  1. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    17
    I have some data contained in a mySQL table that contains line breaks. It's a snail-mail address. How can I have it so that when the data is recalled via PHP it puts a <br> where the newline is so that the data appears on a new line?

    Please reply ASAP, v.urgent

    ------------------
    ------------------------
    Alex
    (http://www.alex-greg.co.uk)
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    see nl2br() in the manual.

    BTW, Alex, you never let me know how that code worked for you.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 1999
    Posts
    114
    Rep Power
    16
  6. #4
  7. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    17
    Rod, i didn't get a chance to use that code, but I emailed you back and told you my database setup, because I suspected that it wouldn't work with the presumed setup.

    ------------------
    ------------------------
    Alex
    (http://www.alex-greg.co.uk)

Similar Threads

  1. reading geometry lines with PHP
    By jianzhong in forum PHP Development
    Replies: 2
    Last Post: January 4th, 2004, 11:55 PM
  2. Reading as many lines from an FFDB as exist?
    By Duminas in forum Perl Programming
    Replies: 2
    Last Post: October 3rd, 2003, 10:49 PM
  3. reading certain lines in a txt file
    By English Guy in forum Perl Programming
    Replies: 7
    Last Post: July 30th, 2003, 09:48 AM
  4. printing required lines to a file.
    By prince in forum Perl Programming
    Replies: 5
    Last Post: July 19th, 2003, 09:29 AM
  5. Animated lines
    By photon in forum Flash Help
    Replies: 2
    Last Post: March 7th, 2003, 08:17 PM

IMN logo majestic logo threadwatch logo seochat tools logo