Using a 'priority' field.

[[deleted]]

I originally posted this over the weekend, but you may have missed it due to the other messages posted afterwards. Anyhow, still looking for help on this.

I am trying to think through the logic of how I could implement a field in the database for preferred order. I can make the field, but I am wondering what the best way, given a list of entries, to create the screen to declare order would be. Each entry would have a text box where you put the value in (1 being the highest) and then going from there. I am sure this is a problem for an array, but not terribly sure about how to implement it.

Thank you.

[brandonschnell]

create a table with a column called priority. have the user specify the priority (bad for customers, good for small sites and system admins) or calculate by using other methods (auction items near to closing time are high priority, etc). then use the SQL "order by priority ASC" to sort the results before displaying to the client.

[[deleted]]

I know how to do an order by, what I want to do is give an administrator a list of things and have them rearrange the order with text fields containing digits.

[brandonschnell]

then create a html form with inputs of type text for each priority, a description, and a hidden (or not so hidden) id for each row. then on the post figure out what rows have changed, and issue updates on the database.

[[deleted]]

I know that much. It's being able to tell what changed and make the appropriate inserts into the database that I am having trouble with.