session variable inside another variable - how?

Question

I have a script that displays countries in different languages. For example "United Kingdom" in Spanish would be "Reino Unido", etc. Every language is stored in a different table, like "name_es" for Spanish or "name_en" for English. The correct table is then selected through a session value stored for each user. What I have is this:

    if ($countries_id)
    {
        $sql_select_countries = $this->query_silent("SELECT name_".$_SESSION['language']." as name FROM " . DB_PREFIX . "countries WHERE
            id IN (" . $countries_id . ")");

        if ($sql_select_countries)
        {
            while ($country_details = $this->fetch_array($sql_select_countries))
            {   
                $countries_array[] = $country_details['name'];
            }
        }
    }

Note that the problem line is this:

$countries_array[] = $country_details['name'];

I need it to be something like

$countries_array[] = $country_details['name_$_SESSION['language']'];

But I can't figure out the correct syntax :(

query_silent() - I like the name!

Your Common Sense
– Your Common Sense

2012-03-25 16:09:14 +00:00
Commented Mar 25, 2012 at 16:09 — Your Common Sense
– Your Common Sense, Commented Mar 25, 2012 at 16:09

shanethehat · Accepted Answer · 2012-03-25 16:47:03Z

1

So you want to concatenate the string 'name_' with the vale stored in session?

$countries_array[] = $country_details['name_'.$_SESSION['language']];

I think if you add some speech marks and curly brackets you can do this:

$countries_array[] = $country_details["name_{$_SESSION['language']}"];

edited Mar 25, 2012 at 16:47

answered Mar 25, 2012 at 16:09

shanethehat

15.6k11 gold badges59 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AlfaTeK · Accepted Answer · 2012-03-25 16:07:00Z

0

$countries_array[] = $country_details[$_SESSION["language"]];

answered Mar 25, 2012 at 16:07

AlfaTeK

7,87514 gold badges54 silver badges92 bronze badges

Collectives™ on Stack Overflow

session variable inside another variable - how?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related