Results 1 to 5 of 5

Thread: Need Some Help in Creating a Database

  1. #1
    5starpix's Avatar
    5starpix is offline Senior Net Builder
    Join Date
    Dec 2008
    Location
    Montreal, Quebec
    Posts
    1,710
    Blog Entries
    9
    Thanks
    158
    Thanked 227 Times in 164 Posts

    Thumbs up Need Some Help in Creating a Database

    Hey guys,

    Looking for a little helping relating to "databases".

    I have some information that I would like to make a database out of.

    The information is basically business listings such as the following

    Business Name: XYZ Canada Ltd
    Business Industry: Manufacturing
    Business Contact#: 1-514-XXX-XXXX

    I have about 2000 records in total.

    How could I create a database with this? Where should I start and using what?

    Any help is appreciated.

    Thanks,

  2. #2
    TopDogger's Avatar
    TopDogger is offline Über Hund
    Join Date
    Jan 2009
    Location
    Hellfire, AZ
    Posts
    3,101
    Thanks
    349
    Thanked 917 Times in 701 Posts
    If it is in a text file format, it is easy to read and write into a MySQL database table using MySQL or PHP.

    Are there just three columns of data?

    Is it in a CSV format? It needs to be in a standard format.

    One possible solution:

    Modwest FAQ and Knowledge Base - How do I import delimited data into MySQL?
    "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- Benjamin Franklin


  3. #3
    5starpix's Avatar
    5starpix is offline Senior Net Builder
    Join Date
    Dec 2008
    Location
    Montreal, Quebec
    Posts
    1,710
    Blog Entries
    9
    Thanks
    158
    Thanked 227 Times in 164 Posts
    The data is actually on a website now. The business listings are on my "mining" related site in my sig. An example of a listing would be this.

    In this case, would I need to enter each record manually?

  4. #4
    bogart's Avatar
    bogart is offline Super Moderator
    Join Date
    May 2009
    Location
    New York
    Posts
    3,772
    Thanks
    1,886
    Thanked 776 Times in 609 Posts
    Is the page connected to a sql database or have you manually entered the directory information to each page?

  5. #5
    5starpix's Avatar
    5starpix is offline Senior Net Builder
    Join Date
    Dec 2008
    Location
    Montreal, Quebec
    Posts
    1,710
    Blog Entries
    9
    Thanks
    158
    Thanked 227 Times in 164 Posts
    I've entered the information manually.

Tags for this Thread

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
  •