$tax) { if(is_numeric($region_id) && is_numeric($tax)) { $previous_tax = $wpdb->get_var("SELECT `tax` FROM `".$wpdb->prefix."region_tax` WHERE `id` = '$region_id' LIMIT 1"); if($tax != $previous_tax) { $wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `tax` = '$tax' WHERE `id` = '$region_id' LIMIT 1"); $changes_made = true; } } } } function country_list($selected_country = null) { global $wpdb; $output = ""; $country_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."currency_list` ORDER BY `country` ASC",ARRAY_A); foreach ($country_data as $country) { $selected =''; if($selected_country == $country['isocode']) { $selected = "selected='true'"; } $output .= ""; } return $output; } if(preg_match("/[a-zA-Z]{2,4}/",$_GET['isocode'])) { $country_isocode = $_GET['isocode']; } else { $country_isocode = get_option('base_country'); } $base_region = get_option('base_region'); ?>

"; } ?>
&isocode=' method='POST' name='regional_tax'> get_row("SELECT * FROM `".$wpdb->prefix."currency_list` WHERE `isocode` IN('".$country_isocode."') LIMIT 1",ARRAY_A); if(($country_data['has_regions'] == 1)) { $region_data = $wpdb->get_results("SELECT `".$wpdb->prefix."region_tax`.* FROM `".$wpdb->prefix."region_tax` WHERE `".$wpdb->prefix."region_tax`.`country_id` IN('".$country_data['id']."') ",ARRAY_A) ; $region_data = array_chunk($region_data, 14); echo "\n\r"; echo " \n\r"; foreach($region_data as $region_col) { echo " \n\r"; } echo " \n\r"; echo "
\n\r"; echo "\n\r"; foreach($region_col as $region) { $tax_percentage = $region['tax']; echo " \n\r"; if($region['id'] == $base_region) { echo " \n\r"; } else { echo " \n\r"; } echo " \n\r"; echo " \n\r"; } echo "
%
\n\r"; echo "
\n\r"; } else { $tax_percentage = $country_data['tax']; echo " "; echo "%"; } ?>