diff options
| -rw-r--r-- | include/checkout/shipping_address | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/include/checkout/shipping_address b/include/checkout/shipping_address index 5b2b24e..2a6c2d1 100644 --- a/include/checkout/shipping_address +++ b/include/checkout/shipping_address @@ -20,7 +20,7 @@ <select name="state" id="province_shipping" class="form-control" onchange="this.form.submit()"> <option value="-- [L]Please select[/L] --">-- [L]Please select[/L] --</option>[perl products] my $options = ''; -for my $province (@{$Tag->query({sql => "SELECT province FROM shipping GROUP BY province ORDER BY province"})}) { +for my $province (@{$Tag->query({sql => "SELECT province FROM anteraja GROUP BY province ORDER BY province"})}) { $options .= qq( <option value="$province->[0]") . ($province->[0] eq $Tag->value({keep => 1, filter => encode_entities, name => 'state'}) ? ' selected' : '') . ">$province->[0]</option>"; } @@ -33,7 +33,7 @@ return $options; <select name="city" id="city_shipping" class="form-control" onchange="this.form.submit()"> <option value="-- [L]Please select[/L] --">-- [L]Please select[/L] --</option>[perl products] my $options = ''; -for my $city (@{$Tag->query({sql => "SELECT city FROM shipping WHERE province='" . $Tag->value({keep => 1, filter => encode_entities, name => 'state'}) . "' GROUP BY city ORDER BY city"})}) { +for my $city (@{$Tag->query({sql => "SELECT city FROM anteraja WHERE province='" . $Tag->value({keep => 1, filter => encode_entities, name => 'state'}) . "' GROUP BY city ORDER BY city"})}) { $options .= qq( <option value="$city->[0]") . ($city->[0] eq $Tag->value({keep => 1, filter => encode_entities, name => 'city'}) ? ' selected' : '') . ">$city->[0]</option>"; } @@ -46,7 +46,7 @@ return $options; <select name="address3" id="district_shipping" class="form-control" onchange="this.form.submit()"> <option value="-- [L]Please select[/L] --">-- [L]Please select[/L] --</option>[perl products] my $options = ''; -for my $district (@{$Tag->query({sql => "SELECT district FROM shipping WHERE city='" . $Tag->value({keep => 1, filter => encode_entities, name => 'city'}) . "' GROUP BY district ORDER BY district"})}) { +for my $district (@{$Tag->query({sql => "SELECT district FROM anteraja WHERE city='" . $Tag->value({keep => 1, filter => encode_entities, name => 'city'}) . "' GROUP BY district ORDER BY district"})}) { $options .= qq( <option value="$district->[0]") . ($district->[0] eq $Tag->value({keep => 1, filter => encode_entities, name => 'address3'}) ? ' selected' : '') . ">$district->[0]</option>"; } |