updating a column after getting every first three row data

Let table has data like this,

no name

1A

2B

3C

4D

5E

6F

First I get the first three rows in the table... after that my table should contain data like this,

no name

1D

2E

3F

4A

5B

6C

that is the data should be updated in cyclic order after displaying the output......

I got the problem while updatting the table....

for example......if i updated the no(column)1 to 4.

while updating no(column)4- 2 rows are being updated .....i.e., the first row is alredy set to 4 and the other row....

[606 byte] By [pdnsrka] at [2007-11-27 2:42:21]
# 1
Use a timestamp field to indicate when a row was updated last and then order on this field.
BalusCa at 2007-7-12 3:06:56 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...