Can you give a few more details?
- What database is it going against? Is 'TIME' a reserved word that you have to quote as a column name?
- What are values of $block_time and $name? (or really, of the actual constructed sql string) (are there quotes in $name or something like that?)
- Are you sure the db connection is open?
- What does $db->Error() have in it?
As a side note, you could be using
DBD::ODBC instead -- one huge advantage is it's (
DBI's) use of placeholders:
$dbh->do("UPDATE USERACCOUNT set TIME = ? WHERE USERNAME = ?", {}, $
+block_time, $name);