CiviCRM Community Forums (archive)

In order to retrieve and display in a custom node the phone and address info of a CiviCRM Contact ($contact_id) I have this query:
$result = db_query("
    SELECT cp.phone,
     ce.email,
     ca.street_address,ca.postal_code,ca.city,ca.geo_code_1,ca.geo_code_2,
     csp.name AS state,
     cc.name AS country
      FROM civicrm_location AS cl
      LEFT JOIN civicrm_phone AS cp
      ON cl.id = cp.location_id
      LEFT JOIN civicrm_email AS ce
      ON cl.id = ce.location_id
      LEFT JOIN civicrm_address AS ca
      ON cl.id = ca.location_id
      JOIN civicrm_state_province AS csp
      ON ca.state_province_id = csp.id
      JOIN civicrm_country AS cc
      ON ca.country_id = cc.id
      WHERE cl.entity_table = 'civicrm_contact'
        AND cl.entity_id = %d
        AND cl.is_primary = 1
        AND ce.is_primary = 1
        AND cp.is_primary = 1
    ",
  $contact_id
  );(note: I don't really need the geo code info)

My drupal modul is not working properly since I've upgraded to CiviCRM 2.0. The database schema has changed in CiviCRM 2.0. I would like to program this nicer using a proper API.

What would be a better way to retrieve address and phone info from the database? Is there an API for this?