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

[PHP] just a php/mysql logic question

2005-08-28 Thread Dave Carrera
Hi All, Just sitting here thing about a php app i am making and an issue i have been aware of but never looked into has made itself apparent to me. Its to do with my php app and transacting with the mysql table of which my records are kept. note: sorry if this goes or is of topic. I have a