Professional Web Applications Themes

hard returns - MySQL

Sorry if this is the wrong newsgroup, but I couldn't see a better one. I'm having a 'simple' problem with MYSQL. I have a block of text that I want to input all together in one cell of data - say a long review of software. I want that long text to be split up into paragraphs having hard returns between them. But. I dont want to have to input <br> after the paragraph end myself, I would like MYSQL to do it for me. The filed in the MYSQL database where the review would be kept is: Field Type ...

  1. #1

    Default hard returns

    Sorry if this is the wrong newsgroup, but I couldn't see a better one.

    I'm having a 'simple' problem with MYSQL.

    I have a block of text that I want to input all together in one cell of
    data - say a long review of software. I want that long text to be split up
    into paragraphs having hard returns between them. But. I dont want to have
    to input <br> after the paragraph end myself, I would like MYSQL to do it
    for me.

    The filed in the MYSQL database where the review would be kept is:

    Field Type Length/Values Collation
    Content longtext latin1_swedish_ci


    Attributes Null Default Extra Comments
    Null Null


    As I'm not an expert at MYSQL I cant see how to do what I want and the
    manual is as clear as mud.

    Any help would be appreciated.

    Thanks.



    --
    Posted via a free Usenet account from http://www.teranews.com

    F9 Guest

  2. #2

    Default Re: hard returns

    F9 wrote: 

    You could do it in MySQL, but I think you'd be better off doing it in
    whatever language you're using.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: hard returns

    "Jerry Stuckle" <net> wrote in message
    news:com... 
    >
    > You could do it in MySQL, but I think you'd be better off doing it in
    > whatever language you're using.[/ref]

    To be honest I am new at this. I set up the MYSQL database with the field
    above and use a PHP design program called "Easygen 2.3" to call the data
    into a template. This is probably an idiots tool as I cant program directly
    in PHP.

    I have looked through its "style sheet editor" and help but there's nothing
    on hard returns. If I knew what to add to the script I could probably do so
    by trial and error.

    I'm going to try one more thing, so will let you know.

    Thanks for help so far.



    --
    Posted via a free Usenet account from http://www.teranews.com

    F9 Guest

  4. #4

    Default Re: hard returns

    "F9" <com> wrote in message
    news:45780f3a$0$15453$teranews.com... 
    >>
    >> You could do it in MySQL, but I think you'd be better off doing it in
    >> whatever language you're using.[/ref]
    >
    > To be honest I am new at this. I set up the MYSQL database with the field
    > above and use a PHP design program called "Easygen 2.3" to call the data
    > into a template. This is probably an idiots tool as I cant program
    > directly in PHP.
    >
    > I have looked through its "style sheet editor" and help but there's
    > nothing on hard returns. If I knew what to add to the script I could
    > probably do so by trial and error.
    >
    > I'm going to try one more thing, so will let you know.
    >
    > Thanks for help so far.[/ref]

    Got this sorted via the Easygen program. Thanks.



    --
    Posted via a free Usenet account from http://www.teranews.com

    F9 Guest

Similar Threads

  1. Eliminating hard returns in OCR
    By scottws@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: December 19th, 04:10 PM
  2. Maintaining Hard Returns
    By wizardofdata in forum Dreamweaver AppDev
    Replies: 2
    Last Post: June 16th, 08:40 PM
  3. Tabs and hard returns into strings in Flash 5 Actionscript
    By Algomeysa2 in forum Macromedia Flash
    Replies: 0
    Last Post: July 29th, 01:14 PM
  4. Soft vs. hard returns
    By Brett Bixler in forum FileMaker
    Replies: 2
    Last Post: July 23rd, 11:08 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139