SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast XploreR's Avatar
    Join Date
    May 2001
    Location
    Singapore
    Posts
    91
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is there any way to solve this?

    Hmm, getting some real troublesome problem for me. LOL That's the best subjest i can think of.

    Ok, i have a table with these 2 fields for my game codes website

    Description | Address |

    I would like to know if anyone has any ideas on how i can solve this.

    Sometimes i have to add an entry wherby the Address fields conatins the following data:


    012AD00000000001
    012AD00000000006
    012AD00000000003
    012AD00000000004


    As u guys know, after i add the data in the mysql would show them as this:


    012AD00000000001012AD00000000006012AD00000000003012AD00000000004


    I have no problems showing the data oput as i know i can use wordwrap, but i don't ;ike the times when i have to edit a particular line in the Address column where the data has more than 10 lines, so i would like to know if anyone knows any idea what i can do about this. Maybe seperate them?

  2. #2
    SitePoint Wizard
    Join Date
    Mar 2001
    Posts
    3,537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Not with that explanation.
    Last edited by 7stud; Jun 7, 2001 at 01:07.

  3. #3
    SitePoint Enthusiast XploreR's Avatar
    Join Date
    May 2001
    Location
    Singapore
    Posts
    91
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is there any way i can edit the entry with ease and have the same output?

    It looks difficult to find the line i want to edit from this:

    012AD00000000001012AD00000000006012AD00000000003012AD00000000004
    Last edited by XploreR; Jun 7, 2001 at 02:12.

  4. #4
    imagine no limitations exbabylon's Avatar
    Join Date
    Dec 2000
    Location
    Idaho, USA
    Posts
    452
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you can select only one at a time from MySQL

    SELECT * FROM table WHERE address LIKE '%AD0000000000%' GROUP BY address;

    That command will work to get each seperate number out. You're being vague
    Blamestorming: Sitting around in a group discussing why a deadline was missed or a project failed and who was responsible.

    Exbabylon- Professional Internet Services


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
  •