Results 1 to 6 of 6

Thread: Parse URL only

  1. #1
    gspinney's Avatar
    gspinney is offline Registered User
    Join Date
    Jul 2003
    Posts
    128

    Question Parse URL only

    Is there a way in the mySQL query/queries on database to just pull a list of the URL's only in `idx_link` `url` ??

  2. #2
    dody is offline Administrator
    Join Date
    Aug 2001
    Location
    Indonesia
    Posts
    3,731

    Default

    try this one:

    insert into `idx_link` (`url`) values ('http://urlhere.com');
    www.nicecoder.com
    www.dodyrw.com

  3. #3
    gspinney's Avatar
    gspinney is offline Registered User
    Join Date
    Jul 2003
    Posts
    128

    Default

    not exactly what I meant.

    I have little over 1000 listings. I wanted to parse out just a list of urls..

    No other details... just the 1000 plus url's.

  4. #4
    ezykiwi is offline Active Member
    Join Date
    May 2004
    Location
    New Zealand
    Posts
    600

    Default hmmm

    I normally just export the database to excel and then you can copy and paste them .... cause they will all be in a col....

    thats just the way i do it...

  5. #5
    gspinney's Avatar
    gspinney is offline Registered User
    Join Date
    Jul 2003
    Posts
    128

    Default

    Quote Originally Posted by ezykiwi View Post
    I normally just export the database to excel and then you can copy and paste them .... cause they will all be in a col....

    thats just the way i do it...
    Well thank's, but I would like to avoid buying Excel to do what should be a pretty simple task... **cough** if I new what that correct parameters where to pull the data from mySQL.


    http://office.microsoft.com/en-us/excel/default.aspx



    ...

  6. #6
    FSGDAG's Avatar
    FSGDAG is offline Moderator
    Join Date
    May 2007
    Location
    NJ, United States
    Posts
    1,651

    Default

    Try using OpenOffice.org. Its Free Open Source and does the same as Excel.
    FSGDAG | IndexU Hosting | Owner
    Website | NiceCoder Script Hosting and More! | Web4URL is For Sale!
    Follow Us On Twitter | FaceBook Profile | YouTube Videos

Similar Threads

  1. a problem with the parse step
    By mankind in forum Extreme Dmoz Extractor - dmoz.org xml parser
    Replies: 2
    Last Post: 04-02-2009, 08:36 PM
  2. Parse error
    By prof in forum v5.x
    Replies: 0
    Last Post: 07-29-2006, 05:52 AM
  3. Mysterious Parse Error
    By petervw in forum v5.x
    Replies: 10
    Last Post: 09-27-2004, 07:21 AM
  4. Parse error on install.php
    By doublep in forum v5.x
    Replies: 0
    Last Post: 01-23-2003, 01:13 PM

Posting Permissions

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