Querying Dialled Numbers?

[russellbcv]

Hi

Does anybody know if there is a method using PHP to query two tables to extract just 'minutes, destination & cost'?

cost = (rate * mins)

At present I have two tables>

1) dialcodes:-

• dialcode
• destination
• rate

2) cdr

• mins
• diallednumber

Within the 'cdr' table all destination have an international prefix with the exception of NGN's & Mobiles.

i.e 44 = uk, 49 = germany, 34 = spain etc.

The problem lies when it comes to germany-mobile "4917".

Does anybody have any idea how one would go about fully rating the calls.?

Thank you in advance

Russ