Country Name via Their Code

[abdul_zu]

Hi all,

I have tow database in different server

1- Having the complete [country code + area + phone] telephone numbers. (I don’t have permission to modify the database or table)

2- Having Country Name and their Codes. (I have the permission to modify the database or table)

Now I want to retrieve the Country name with matching of first database table which contained only telephone numbers.

For the example

First database has the telephone no. of 9745405022
Second database has the code and name filed name like
Country_ name country_code
QATAR 974

So the result should be come on user browser QATAR when he entered the complete telephone number of QATAR.

Sorry I am new in PHP and MySQL so it seems very hard for me please if some one idea ………. Help me.

Thank you,

[tsinka]

Hi,

this should work:

$phone = "9745405022";

$sql = "SELECT country_name FROM country_codes WHERE '$phone' REGEXP CONCAT('^',country_code)";

Thomas

[abdul_zu]

Hi Thomas,

Thank you for your reply. I solved my problem with other ways.

Abdul Lateef :p