Re: [PHP] just a php/mysql logic question

2005-08-28 Thread Jasper Bryant-Greene
Evert | Rooftop wrote: Reading all this I suddenly realise I have the same problem. I'm using a modified tree traversal alghoritm to store my tree in the database, but when I insert a new node I assign new ID's based on a SELECT query. I think I can deal with it with the combined UPDATE..SELECT

Re: [PHP] just a php/mysql logic question

2005-08-28 Thread Robert Cummings
On Sun, 2005-08-28 at 15:58, Satyam wrote: > "Robert Cummings" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > On Sun, 2005-08-28 at 06:10, Jasper Bryant-Greene wrote: > >> Dave Carrera wrote: > >> > If multiple users hit the php app at the same time how do i ensure that > >> > t

Re: [PHP] just a php/mysql logic question

2005-08-28 Thread Evert | Rooftop
Reading all this I suddenly realise I have the same problem. I'm using a modified tree traversal alghoritm to store my tree in the database, but when I insert a new node I assign new ID's based on a SELECT query. I think I can deal with it with the combined UPDATE..SELECT query. Right now an ano

Re: [PHP] just a php/mysql logic question

2005-08-28 Thread Satyam
"Robert Cummings" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Sun, 2005-08-28 at 06:10, Jasper Bryant-Greene wrote: >> Dave Carrera wrote: >> > If multiple users hit the php app at the same time how do i ensure that >> > the correct amount of stock is taken from stock so that

Re: [PHP] just a php/mysql logic question

2005-08-28 Thread Robert Cummings
On Sun, 2005-08-28 at 06:10, Jasper Bryant-Greene wrote: > Dave Carrera wrote: > > If multiple users hit the php app at the same time how do i ensure that > > the correct amount of stock is taken from stock so that a users does not > > accidentally sell from stock which has already been sold. >

Re: [PHP] just a php/mysql logic question

2005-08-28 Thread Jasper Bryant-Greene
Dave Carrera wrote: If multiple users hit the php app at the same time how do i ensure that the correct amount of stock is taken from stock so that a users does not accidentally sell from stock which has already been sold. Even though multiple users may hit the PHP app "at the same time" (even