Getting/Displaying the Customer's Country

[ultimate_zc]

Thanks,

I got it working with this:

        $country_query = "SELECT entry_country_id FROM " . TABLE_ADDRESS_BOOK . " WHERE customers_id = :customersID";
        $country_query = $db->bindVars($country_query, ':customersID', $_SESSION['customer_id'], 'integer');
        $check_customer = $db->Execute($country_query);
        $customer_country= $check_customer->fields['entry_country_id'];
        $country = zen_get_country_name($customer_country); 

[Design75]

Thanks,

I got it working with this:

        $country_query = "SELECT entry_country_id FROM " . TABLE_ADDRESS_BOOK . " WHERE customers_id = :customersID";
        $country_query = $db->bindVars($country_query, ':customersID', $_SESSION['customer_id'], 'integer');
        $check_customer = $db->Execute($country_query);
        $customer_country= $check_customer->fields['entry_country_id'];
        $country = zen_get_country_name($customer_country); 

What happens if the customer has multiple countries in his address book ?

[Ajeh]

When a customer logs in, the country id is set to:
$_SESSION['customer_country_id']

You could use that to look up the country name in the countries table ...

[ultimate_zc]

Thanks to you both.