Re-Ordering Records in a DB

Results 1 to 2 of 2

Thread: Re-Ordering Records in a DB

  1. #1
    Join Date
    Dec 1969

    Default Re-Ordering Records in a DB

    I have let&#039;s say 10 records in a database and I would like the user to have control of the order in which they are displayed. Can anyone tell me the best way to go about this?<BR><BR>Should I create another field called sort_id and have the users update that field? Is it possible to update all the records at once? Has anyone done anything like this before? If anyone has used Netflix, I want to do something like the Queue they do.<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Yes, add a field...

    ...and yes, you can update all records at once, so long as you update expression *applies* to all records.<BR><BR>Which it probably can&#039;t do in the general reordering case.<BR><BR>So you will probably end up doing UPDATE on one record at a time.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts