Just a few things i can mention, without actually knowing your error message (please include next time) ...

1. your connect() has "um" where i would expect "dbi:mysql:SERVER", also, missing login and pass. Xomsthing line : DBI->connect("dbi:mysql:localhost",$user,$pass) || die "foo : $!\n";
2. You need to quote your SQL in the prepare() statement.
3. You may want to use $dbh->do() if you are doing inserts ... a bit easier to read.
4. Lastly, i would suggest posting the actual problem you are having (error message, etc) so people can give more precise answers.

---

The requirements change because they don't know what they want, or how much they own you.