On Thu, Apr 8, 2010 at 12:09 PM, Mr. Lawi <mail2lawi@gmail.com> wrote:

Good one, Peter,

Maybe u can extend it and use some form of mapping table with a mobile network id and the network names so that in case a network changes its name (as is bound to happen with Zain, or so I hear) all u have to do is change the network name in the mapping table.

...

On Thu, Apr 8, 2010 at 11:49 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:

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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
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-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke