Aah, thought about it, but decided to make my life easier coz i have a select thingy where the user selects the prefix, using my script, i only have to: 1. Append the leading zero Using your suggestion, I would have to: 1. Append the leading zero 2. Write a loop to add the trailing 0, 1, 2 ... 9 to make 0720, 0721, 0722 ... 0729 3. Write more code to know that 71 starts from 710 and ends at 719 On Thu, Apr 8, 2010 at 11:35 AM, Joe Murithi Njeru <joe.njeru@gmail.com>wrote:
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
_______________________________________________ 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