Mine

$update_hits = mysql_query("UPDATE wp_usermeta SET user_hits = user_hits +1 WHERE umeta_id = '" . the_author_ID() . "'", $connection);

if (!$update_hits) {
	die("Unable to update user hits: " . mysql_error());
}