$ticket = $query->param('TicketNo'); $detail = $query->param('Detail'); . . . my $temp1 = "UPDATE TSIssuesTable "; my $temp2 = "SET Detail = ?"; my $temp3 = "WHERE "; my $temp4 = "TicketNo = $ticket"; $SQL = $temp1.$temp2.$temp3.$temp4; $sth1 = $dbh->prepare( $SQL ); $sth1->execute($details); ...