Hi!
I have some data records which are enumerated by an integer field. This field is neiter a key, nor AUTO_INCREMENT nor unique or anything. it's just a normal field ;-)
i get the records from the table in order of that numbers by using "SELECT * FROM Table ORDER BY FieldName;"
now i would like to be able to move records around that order!
for instance, i would like to be able to move record number 30 between record number 4 and 5. then of course, every number past record 5 has to be increased by one.
of couse i also want to be able to move a record forwards!
Does anybody know/have a solution for this problem?
Thanks in advance!
Jan
I have some data records which are enumerated by an integer field. This field is neiter a key, nor AUTO_INCREMENT nor unique or anything. it's just a normal field ;-)
i get the records from the table in order of that numbers by using "SELECT * FROM Table ORDER BY FieldName;"
now i would like to be able to move records around that order!
for instance, i would like to be able to move record number 30 between record number 4 and 5. then of course, every number past record 5 has to be increased by one.
of couse i also want to be able to move a record forwards!
Does anybody know/have a solution for this problem?
Thanks in advance!
Jan