- my $total = $sth->fetchrow_hashref;
- $sth->finish;
- $template->param(total => $total->{'total'});
- my $sth2=$dbh->prepare("select cityid,city_name,city_zipcode from cities where cityid=?");
- $sth2->execute($cityid);
- my $data=$sth2->fetchrow_hashref;
- $sth2->finish;
- if ($total->{'total'} >0) {
- $template->param(totalgtzero => 1);
- }
-
- $template->param(
- city_name => ( $data->{'city_name'}),
- city_zipcode => $data->{'city_zipcode'});
-
-
- # END $OP eq DELETE_CONFIRM
+ my $data=$sth->fetchrow_hashref;
+ $template->param(
+ city_name => $data->{'city_name'},
+ city_state => $data->{'city_state'},
+ city_zipcode => $data->{'city_zipcode'},
+ city_country => $data->{'city_country'},
+ );