$query = "UPDATE account ". "SET balance = balance - $amount, ". "lastchange = NOW(), ". "WHERE id = '$uid'"; $res1 = db_query($query);