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;