Re: am I using massive resource for sending mySQL qurey through PHP?

[Yousef Al-Hadhrami]

the description in short simple English? ok
I am trying to use one mySQL query to change a group of rows

live example
changing
--------------------------------------
| id | name | position |
--------------------------------------
| 1 | a | 5 |
| 2 | b | 3 |
| 3 | c | 1 |
| 4 | d | 2 |
| 5 | e | 4 |
--------------------------------------

to

--------------------------------------
| id | name | position |
--------------------------------------
| 3 | c | 1 |
| 4 | d | 2 |
| 2 | b | 3 |
| 5 | e | 4 |
| 1 | a | 5 |
--------------------------------------

sending only 1 mySQL query through PHP for all of that