On Jan 17, 11:47 pm, Michael <[email protected]> wrote: > I want to do a SELECT and UPDATE in one statement.
If you want to ensure exclusive access to the selected row(s) for update, have a look at SELECT ... FOR UPDATE: http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html Mal --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
