On May 15, 10:11 am, subtenante <zzsubtenant...@gmail.com> wrote:
> On 15 May 2007 01:15:28 -0700, Mohawk Mawk <blessblessbl...@gmail.com>
> wrote:
>
>
>
> >Hey guys,
> >I'm new here and I hope its OK if I tap a lil into your knowledge
> >base.
>
> >I have a table
>
> >ID|Name|Job
>
> >the ID is an int that auto increases and should stay the same for
> >history record.
> >Now I want to put order to the table.
> >Not by ID, not by name, not by job.
> >so I want to add a order collumn, but I'm not sure what values it
> >should have.
> >I want to list the names and decide to move them up or down in order.
> >e.g.
>
> >ID:1-Steve-Farmer (move up in order button)(move down in order button)
> >ID:2-Jim-Hunter (move up in order button)(move down in order
> >button)
> >ID:3-Al-Baker (move up in order button)(move down in order
> >button)
>
> >then if i click the (move up in order button) from Jim the list would
> >look like this
>
> >ID:2-Jim-Hunter (move up in order button)(move down in order
> >button)
> >ID:1-Steve-Farmer (move up in order button)(move down in order button)
> >ID:3-Al-Baker (move up in order button)(move down in order
> >button)
>
> >i hope you get the gist of what I want.
> >so what values should i use and how should they change to get the
> >effect I want? the list will probably be huge and its not really about
> >jobs and names but i just used this as an example.
> >Thanks for any ideas
> >Mawk
>
> You might need another field : parent, same type as your ID, and being
> unique.
> You also need a top-row with ID 0 or something of the kind you will
> never change.
>
> ID:0-EMPTY-EMPTY Parent:NULL
> ID:1-Steve-Farmer Parent : 0
> ID:2-Jim-Hunter Parent 1
> ID:3-Al-Baker Parent 2
>
> Then when you hit on Jim to put it up, you update Jim and Steve, to
> have Jim having EMPTY as Parent, and Steve having Jim.
>
> Then you SELECT everything again, and you always ORDER BY Parent.

http://www.phpriot.com/d/articles/cl...jax/index.html