Wouldn't it be simpler to just have: insert into `tblmobile_prefixes`(`id`,`ndc`,`operator`) values (1,'71','Safaricom'),(2,'72','Safaricom'),(3,'73','Zain'),(4,'75','Yu'),(5,'77','Orange'); ? -----Original Message----- From: Peter Karunyu <pkarunyu@gmail.com> Reply-to: Skunkworks Mailing List <skunkworks@lists.my.co.ke> To: Skunkworks forum <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] Mobile phone operator prefixes Date: Thu, 8 Apr 2010 11:21:55 +0300 Decided to create one, attached here. I might as well create one for landlines while I am at it. On Thu, Apr 8, 2010 at 10:53 AM, Peter Karunyu <pkarunyu@gmail.com> wrote: Good people, Anyone got a SQL script or CSV file with prefixes for the different network operators and willing to share? Something like: 0700 - Safaricom 0710 - Safaricom 0733 - Zain etc The closest I can find on the CCK website is a PDF, National Numbering Plan for 2008. http://www.cck.go.ke/licensing/numbering/plan.html And its not updated since the other day I saw 0700 being sold on the streets... _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke@ -- Regards, Joe Linux User: #361092 SIP: joe.njeru@ekiga.net