Results 1 to 4 of 4

Thread: Formatting text using BLOB

  1. 02-03-2003, 01:16 PM #1
    bygmony
    bygmony is offline Registered User
    Join Date
    Feb 2003
    Location
    VA
    Posts
    10

    Question Formatting text using BLOB

    I am developing a MySql database that will take large amounts of text (media stories) and display it on the web.

    The problem I have is the formatting of the story gets lost (the hard returns). How do I keep the original format after the story has been put into the database. The story is being submitted via a web form.

    Thanks
    Reply With Quote Reply With Quote
  2. 02-05-2003, 05:24 AM #2
    greenman
    greenman is offline Registered User
    Join Date
    Dec 2002
    Location
    Cape Town, South Africa
    Posts
    75
    Please see the MySQL forum for the rest of this thread.
    Reply With Quote Reply With Quote
  3. 02-11-2003, 05:54 PM #3
    pkg
    pkg is offline Registered User
    Join Date
    Feb 2003
    Location
    Sweden
    Posts
    1

    formatting

    I had the same problem, and I fix it by used datatype: "text", insted for "blob" in MySQL.
    Then for textarea I had set wrap="VIRTUAL".


    When Yuo get data from the database, use "nl2br()", like: "echo nl2br($value[2]);"

    Hope it's help.......

    ...PKG...
    Reply With Quote Reply With Quote
  4. 02-25-2003, 08:46 AM #4
    bygmony
    bygmony is offline Registered User
    Join Date
    Feb 2003
    Location
    VA
    Posts
    10

    Thanks PKG

    PKG that script worked wonderfully. I thank you for that.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules