If you are familiar with PHP Nuke, maybe you can help me...?

I modified Nuke 6.0 so that users can select their country and city. I also added search possibilities so that user can find other users from his/her country, city. The only problem is language.

So, I need that instead of country name only number is being entered in MySQL, for example:

for Austria = value "1"
for Germany = value "2"
for Russia = value "3"
etc...

But how to display the country name depending of langue what user choosed in PHP Nuke?

The only way I know is:

if ($userinfo[country] == '1') {

echo ""._COUNTRY1."";
}

if ($userinfo[country] == '2') {

echo ""._COUNTRY2."";
}

But I can not do this for more than 100 countries and more than 1000 cities...

I tried this:
$COUNTRY = $userinfo[country];
echo ""._$COUNTRY."";

But all that I get are parse errors... Is there some way that I can list all countries in all language files (in English language file - country names in English, in Russian language file - country names in Russian, in German language file - country names in German) and to display them correctly depending of value in MySQL?

Sorry for my English. I hope you understand what I need.

Thank you.

    Why not create a small table with this information in it and do a quick look up? You could also do queries that do all the work for you so you don't even have to do anything on the PHP side.

      Write a Reply...