Re: Concurent requests

From: "Daniel B I" <bignat@mail.com> Sent: Friday, March 09, 2001 1:49 PM > Please, any idea how to manage concurent requests, > for example like in a shopping cart? <snip> > Any idea how to fix this transaction problem? If A is locked by the > first client in order to fix this problem, there is another question (the > really one!): > > If the program terminates unexpectedly, what about A? > It remains locked forever, and the second client cannot use it > anymore ? Well, you've said it yourself: It's a transaction problem, so it should be solved with transaction control. Use a database with transaction control like MySql with BDB tables. Or you could try with MySql's locking functionality. If your script/connection dies, the locks are released (AFAIK). But don't use persistent connections then. - Carsten