>Can't you do the select and update as part of one transaction? > > > >For example with MySQL: > >START TRANSACTION; > >SELECT @A:=SUM(salary) FROM table1 WHERE type=1; > >UPDATE table2 SET summa...@a WHERE type=1; > >COMMIT; >
AFAIK it is the transaction. Problem is that update will work for all three users. Adding expiry_time IS NULL to update will cause it to work only for the first user. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html