How to split text from mysql

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    How to split text from mysql

    Hello friends please help.
    How can i split text from mysql.
    For example i have stored a lyric in db.
    "I threw a wish in the well
    Don’t ask me I’ll never tell
    I looked at you as it fell
    And now you’re in my way
    I trade my soul for a wish
    Pennies and dimes for a kiss
    I wasn’t looking for this
    But now you’re in my way
    Your stare was holding
    Ripped jeans
    Skin was showing
    Hot night
    Wind was blowing
    Where you think you’re going baby?
    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    It’s hard to look right at you baby
    But here’s my number
    So call me maybe
    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    And all the other boys
    Try to chase me
    But here’s my number
    So call me maybe
    You took your time with the call
    I took no time with the fall
    You gave me nothing at all
    But still you’re in my way
    I beg and borrow and steal
    At first sight and it’s real
    I didn’t know I would feel it
    But it’s in my way
    Your stare was holding
    Ripped jeans
    Skin was showing
    Hot night
    Wind was blowing
    Where you think you’re going baby?
    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    It’s hard to look right at you baby
    But here’s my number
    So call me maybe
    Before you came into my life
    I missed you so bad
    I missed you so bad
    I missed you so so bad
    Before you came into my life
    I missed you so bad
    and you should know that
    I missed you so so bad, bad, bad, bad….
    It’s hard to look right at you baby
    But here’s my number
    So call me maybe
    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    And all the other boys
    Try to chase me
    But here’s my number
    So call me maybe
    Before you came into my life
    I missed you so bad
    I missed you so bad
    I missed you so so bad
    Before you came into my life
    I missed you so bad
    and you should know that
    so call me, maybe
    ---"
    Now i want to split

    Now i want to soit text
    like following
    I threw a wish in the well
    Don’t ask me I’ll never tell
    I looked at you as it fell
    And now you’re in my way

    I trade my soul for a wish
    Pennies and dimes for a kiss
    I wasn’t looking for this
    But now you’re in my way

    Your stare was holding
    Ripped jeans
    Skin was showing
    Hot night
    Wind was blowing
    Where you think you’re going baby?

    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    It’s hard to look right at you baby
    But here’s my number
    So call me maybe

    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    And all the other boys
    Try to chase me
    But here’s my number
    So call me maybe
    ///Break show ad or do something
    You took your time with the call
    I took no time with the fall
    You gave me nothing at all
    But still you’re in my way
    ///Break show ad or do something
    I beg and borrow and steal
    At first sight and it’s real
    I didn’t know I would feel it
    But it’s in my way

    Your stare was holding
    Ripped jeans
    Skin was showing
    Hot night
    Wind was blowing
    Where you think you’re going baby?

    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    It’s hard to look right at you baby
    But here’s my number
    So call me maybe

    Before you came into my life
    I missed you so bad
    I missed you so bad
    I missed you so so bad
    Before you came into my life
    I missed you so bad
    and you should know that
    I missed you so so bad, bad, bad, bad….

    It’s hard to look right at you baby
    But here’s my number
    So call me maybe

    Hey I just met you
    And this is crazy
    But here’s my number
    So call me maybe
    And all the other boys
    Try to chase me
    But here’s my number
    So call me maybe
    ///Break show ad or do s
    Before you came into my life
    I missed you so bad
    I missed you so bad
    I missed you so so bad
    Before you came into my life
    I missed you so bad
    and you should know that
    so call me, maybe
    ---

    How can i do it?
    What should be my MySQL query? Any special technique?
    Thanks

    #2
    you can only add a double line break every 4/5 etc lines of text,
    but the way it is in your example its possible only manually.
    Advertise your mobile site for FREE with AdTwirl

    Comment


      #3
      i think nl2br() function will help u .. only if u saving your txt like u posted here .

      Comment

      Working...
      X