Hello All,
This may be a bit off topic. If so, my apololgies.
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 t
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. Fo
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 doab
andy
Cc: [EMAIL PROTECTED]
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 $idr
3 10:30 AM
> To: Rankin, Randy; [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
> > havin