; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Help with MySQL Logic
A client of mine, a rail car storage company, has asked that I create a
PHP/MySQL application in which they will maintain and track rail cars. I
am
having a bit of trouble however working through one of thier
requirements
Heh. Sounds like a programming class homework project.
I would say through the clever use of where clauses's, like:
UPDATE position SET posistion = (position-1) WHERE position $idremoved;
Would work, assuming $idremoved containted the position of the car removed.
On Mon, 2003-03-03
A client of mine, a rail car storage company, has asked that I create a
PHP/MySQL application in which they will maintain and track rail cars. I
am
having a bit of trouble however working through one of thier requirements.
They need to know in what position the rail car is on each track. For
What about two tables, one would have this:
carID
carCompany
carPayload
etc...
the second this:
position
carID
This table would be static and if a car was not present in certain conditions
they would contain (-1) for the carID. Then finding an empty slot to place an
incoming car should be
]
Subject: Re: [PHP-DB] Help with MySQL Logic
Heh. Sounds like a programming class homework project.
I would say through the clever use of where clauses's, like:
UPDATE position SET posistion = (position-1) WHERE position $idremoved;
Would work, assuming $idremoved containted the position