Re: [PHP] swaping mysql table values

2005-03-08 Thread Richard Lynch
Dave Carrera wrote: > Hi List, > > I have a table like the diag below: > > ID Name Pos > 1 jig 1 > 2 pig 2 > 3 dig 3 > 4 fig 4 > > What i am trying to do is upon click to change pos 1 to pos 2 and pos 2 > to pos 1so that i can manage the position i show my list. > > Can someone throw me

Re: [PHP] swaping mysql table values

2005-03-05 Thread Jochem Maas
Dave Carrera wrote: Hi List, I have a table like the diag below: ID Name Pos 1 jig 1 2 pig 2 3 dig 3 4 fig 4 What i am trying to do is upon click to change pos 1 to pos 2 and pos 2 to pos 1so that i can manage the position i show my list. Can someone throw me some nuggets of logic wisdom