in reply to dbi insert

mysql has a quirky syntax for the insert statement. while the previous posts are correct to point out that you should use placeholders, i think you'll have better luck with this syntax

$dbs=$dbh->prepare("insert into people set (fornavn=?,efernavn=?...)"); and then
execute the statement handle with the relevant scalars as merlyn suggests.