Hi
I have a table in database in that data is enterd different countrycode for same country
i wrote query for getting countrycode and country..it’s fine
but what happing is when i tried to call that query in to application,in application that coutry name is displaying twice based on countrycode
but
i don’t want to reapet the same country code in the dropdown
i want to display country name only once for different countrycode whose comes under same country
coutry_code country
12 xxxx
13 xxxx
14 xxxx
the data is like this
i am working in PHP
with mysql
can u plz suggest me for logic behind this