Populate a db into wordpress

Discussion in 'Services' started by streetjammer123, Aug 9, 2008.

  1. #1
    I have a database containing about 89758 record .

    Here is the example of the record .

    Structure


    CREATE TABLE IF NOT EXISTS `plants` (
      `id` int(10) NOT NULL default '0',
      `symbol` varchar(255) NOT NULL default '',
      `scientific` varchar(255) NOT NULL default '',
      `common` varchar(255) NOT NULL default '',
      `family` varchar(255) NOT NULL default '',
      PRIMARY KEY  (`id`)
    Code (markup):


    
    INSERT INTO `plants` VALUES (1, 'ABELI', 'Abelia R. Br.', 'abelia', 'Caprifoliaceae');
    Code (markup):
    1) I want to arrange the symbol in alphabetical order .
    2) I want to populate / insert into wordpress database so that i can make a website


    PM Me with your offers. Pay You in paypal
     
    streetjammer123, Aug 9, 2008 IP
  2. mal4o

    mal4o Active Member

    Messages:
    351
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    78
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    send me a PM with more information about what do you need
     
    mal4o, Aug 9, 2008 IP
  3. skzubair

    skzubair Well-Known Member

    Messages:
    514
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    135
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Can you please give more details about your exact requirements :)
     
    skzubair, Aug 9, 2008 IP
  4. streetjammer123

    streetjammer123 Banned

    Messages:
    321
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    i want to make it as a wordpress site
     
    streetjammer123, Aug 9, 2008 IP
  5. kishore415

    kishore415 Well-Known Member

    Messages:
    1,462
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    160
    As Seller:
    100% - 0
    As Buyer:
    25.0% - 1
    #5
    The site is down i think....
     
    kishore415, Aug 9, 2008 IP
  6. streetjammer123

    streetjammer123 Banned

    Messages:
    321
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    SAMPLE SQL

    Table structure for table `plants`
    -- 
    
    DROP TABLE IF EXISTS `plants`;
    CREATE TABLE IF NOT EXISTS `plants` (
      `id` int(10) NOT NULL default '0',
      `symbol` varchar(255) NOT NULL default '',
      `scientific` varchar(255) NOT NULL default '',
      `common` varchar(255) NOT NULL default '',
      `family` varchar(255) NOT NULL default '',
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- 
    -- Dumping data for table `plants`
    -- 
    
    INSERT INTO `plants` VALUES (1, 'ABELI', 'Abelia R. Br.', 'abelia', 'Caprifoliaceae');
    INSERT INTO `plants` VALUES (2, 'ABGR4', 'Abelia ?grandiflora (Rovelli ex Andr?) Rehd. [chinensis ? uniflora]', 'glossy abelia', 'Caprifoliaceae');
    INSERT INTO `plants` VALUES (3, 'ABELM', 'Abelmoschus Medik.', 'okra', 'Malvaceae');
    INSERT INTO `plants` VALUES (4, 'ABES', 'Abelmoschus esculentus (L.) Moench', 'okra', 'Malvaceae');
    INSERT INTO `plants` VALUES (5, 'HIES', 'Hibiscus esculentus L.', 'Abelmoschus esculentus', 'Malvaceae');
    INSERT INTO `plants` VALUES (6, 'ABMA9', 'Abelmoschus manihot (L.) Medik. [excluded]', '', 'Malvaceae');
    INSERT INTO `plants` VALUES (7, 'HIMA9', 'Hibiscus manihot L. [excluded]', 'Abelmoschus manihot', 'Malvaceae');
    INSERT INTO `plants` VALUES (8, 'ABMO', 'Abelmoschus moschatus Medik.', 'musk okra', 'Malvaceae');
    INSERT INTO `plants` VALUES (9, 'HIAB', 'Hibiscus abelmoschus L.', 'Abelmoschus moschatus', 'Malvaceae');
    Code (markup):
     
    streetjammer123, Aug 10, 2008 IP