$check_sql = "SELECT state_name, region" . " FROM States" . " WHERE state_id = '" . $field_state_id . "'"; $nm_select = $check_sql; $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nm_select; $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; $this->rs = array(); if ($SCrx = $this->Db->Execute($nm_select)) { $SCy = 0; $nm_count = $SCrx->FieldCount(); while (!$SCrx->EOF) { for ($SCx = 0; $SCx < $nm_count; $SCx++) { $this->rs[$SCy] [$SCx] = $SCrx->fields[$SCx]; } $SCy++; $SCrx->MoveNext(); } $SCrx->Close(); } elseif (isset($GLOBALS["NM_ERRO_IBASE"]) && $GLOBALS["NM_ERRO_IBASE"] != 1) { $this->rs = false; $this->rs_erro = $this->Db->ErrorMsg(); } ; if (isset($this->rs[0][0])) { $other_field = $this->rs[0][0]; $other_region = $this->rs[0][1]; } else { $other_field = ''; $other_region = ''; }