swaping mysql table values
| From: | Dave Carrera | Date: | Sat, 05 Mar 2005 09:48:00 +0000 |
| Subject: | swaping mysql table values | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-210064@lists.php.net to get a copy of this message | ||
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 as my searchs are coming up blank.
Thanks you in advance
Dave C