CiviCRM Community Forums (archive)

I am adding a hyper link from the contact view page that points to my clients main website. They want the name and address passed to them in a URL. I am editing summary.tpl where I have found out all the tokens I need except the state abbreviation and the country name. The tokens that I have found are state_province_id and country_id which both return what I assume is a primary key. Are there any tokens available that will return the state abbreviation and the country name or do I have to perform a database lookup?
Ross

Specifically the tokens I can find are as follows:
STATE: {$address.1.state_province_id}
COUNTRY: {$address.1.country_id}

Thanks, I was afraid of that. Any idea what the specific query string would be for this? I don't not have direct access to view the MySQL tables.....

Ros

Thank you! Exactly what I needed.     I am a long time wordpress developer, newbie to Drupal and CivicRM

To summarize what I have learned:

The file 'CRM/Core/PseudoConstant.php' contains all sorts of info that is helpful to the CivicRM developer
The INC files located in 'drupal/modules/views/civicrm' contained everything I needed for my task at hand

To retrieve states and/or countries:

    require_once 'CRM/Core/PseudoConstant.php';
    $_states = CRM_Core_PseudoConstant::stateProvinceAbbreviation();  //optionally pass state_province_id to get a specific state
    $_countries = CRM_Core_PseudoConstant::country( );  //optionally pass country_id to get a specific country

-Ross