public static function getAllSecondaryCurrencies($lab_config_id, $default_currency) { $saved_db = DbUtil::switchToLabConfig($lab_config_id); $query_string = "SELECT distinct currencyb FROM currency_conversion where currencya='{$default_currency}'"; $resultset = query_associative_all($query_string, $row_count); $record_c = array(); foreach ($resultset as $record) { foreach ($record as $key => $value) { $query_string = "SELECT * FROM currency_conversion WHERE currencya='{$value}' && currencya=currencyb"; $record_each = query_associative_one($query_string); $record_c[] = currencyConfig::getObject($record_each); } } DbUtil::switchRestore($saved_db); return $record_c; }