That makes so much sense for this scenario, very intriguing, but I can't find your enclosed code.
Ok first code had some errors in it..
A little work was done to fix this.. Below are the updates
CREATE TABLE `cc_route` (
`id_provider` int(11) NOT NULL auto_increment,
`npanxx` varchar(50) default NULL,
`price` double default NULL,
`provider` varchar(50) default NULL,
`spoofCid` varchar(25) default NULL,
`Prefix` varchar(25) default NULL,
PRIMARY KEY (`id_provider`),
KEY `npannx` (`npanxx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1