if ($input->param('roadtypeid') ){
$sth=$dbh->prepare("UPDATE roadtype SET road_type=? WHERE roadtypeid=?");
- $sth->execute($input->param('roadtypeid'),$input->param('road_type'));
+ $sth->execute($input->param('road_type'),$input->param('roadtypeid'));
}
else{
$template->param(else => 1);
my @loop;
my ($count,$results)=StringSearch($searchfield,'web');
- my $toggle = 0;
for (my $i=0; $i < $count; $i++){
my %row = (roadtypeid => $results->[$i]{'roadtypeid'},
- road_type => $results->[$i]{'road_type'},
- toggle => $toggle );
+ road_type => $results->[$i]{'road_type'});
push @loop, \%row;
- if ( $toggle eq 0 )
- {
- $toggle = 1;
- }
- else
- {
- $toggle = 0;
- }
}
$template->param(loop => \@loop);