CiviCRM Community Forums (archive)

I am relatively new to Civi development and have been developing a payment processor for a direct debit collection of donations. I have a profile that collects some information before sending on to the processor. The individual_prefix and state_province-Primary paramerters passed from the form are codes and I have prepared the following code to access the name from the database:

      // Fetch County Name from Database
      $query =   "SELECT name
               FROM civicrm_state_province
               WHERE id = ".$params['state_province-Primary'];
      # run the query
      $dao = CRM_Core_DAO::executeQuery( $query );
      while ( $dao->fetch() ) {
         $RapidataParams['county'] = $dao->name;
      }

I would appreciate any comments on whether there is better or more appropriate way to get at this data.