my $sql = 'INSERT INTO ' . $table . '(title, author, lesson_summary, recommended, grades, rationale, standards) VALUES (?, ?, ?, ?, ?, ?, ?)'; my $sth = $dbh->prepare($sql); $sth->execute( $template->param('Title'), $ENV{'REMOTE_USER'}, $template->param('Summary'), $template->param('Recommended'), $grades, $template->param('Rationale'), $standards ); #### update lesson_temp set id= '4' where id = 5; #### select * from lesson_temp where id = 4;