update set money = money + 1
как было написано изначальноmysqli_query($db, 'start transaction');
mysqli_query($db, " SELECT `money` FROM `dle_users` WHERE `name`='HardBIT' FOR UPDATE");
...
mysqli_query($db, " UPDATE `dle_users` SET `money` = ... ");
mysqli_query($db, "COMMIT");