function get_currencies($handle = null) { if (empty($handle)) { $handle = DbConnect(); } $instance_table = new Table(); $QUERY = "SELECT id,currency,name,value from cc_currencies order by id"; $result = $instance_table->SQLExec($handle, $QUERY); /* $currencies_list['ADF'][1]="Andorran Franc"; $currencies_list['ADF'][2]="0.1339"; [ADF] => Array ( [1] => Andorran Franc (ADF), [2] => 0.1339 ) */ if (is_array($result)) { $num_cur = count($result); for ($i = 0; $i < $num_cur; $i++) { $currencies_list[$result[$i][1]] = array(1 => $result[$i][2], 2 => $result[$i][3]); } } if (isset($currencies_list) && is_array($currencies_list)) { sort_currencies_list($currencies_list); } return $currencies_list; }
function get_currencies($handle = null) { if (empty($handle)) { $handle = DbConnect(); } $instance_table = new Table(); $QUERY = "SELECT id, currency, name, value FROM cc_currencies ORDER BY id"; $result = $instance_table->SQLExec($handle, $QUERY, 1, 300); if (is_array($result)) { $num_cur = count($result); for ($i = 0; $i < $num_cur; $i++) { $currencies_list[$result[$i][1]] = array(1 => $result[$i][2], 2 => $result[$i][3]); } } if (isset($currencies_list) && is_array($currencies_list)) { sort_currencies_list($currencies_list); } return $currencies_list; }