Re: increment/rank

On Tue, Dec 19, 2000 at 07:29:33PM -0700, Dan Harrington wrote:
> I get a two-record list of:
> ----------------------------------------------------------------------------
> -
> Peaceful Stream    |    image/stream.jpg    | water peace        | 102
> Wide Stream        |    image/wide.jpg    | water peace flowing    | 101
> ----------------------------------------------------------------------------
> -
> ...and I select "Wide Stream", I want to change the rank number from 101 to
> 102.

Your description of the problem is ambiguous, and so my answer which
is very simplistic may not be useful at all.  Properly set-up tables
need a primary key which is unique for each record; I'm making the
bold assumption that in your case the image filename will do as a
primary key.  So if you only want to "change the rank number" you
could do something like

update images set rank=102 where filename='image/wide.jpg'.

If the rank field has more semantics than you mentioned in your email,
you should define them for us.


--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233   Fx: +61 2 9361 4633