Forum Moderators: open
Not sure quite how to describe what I am trying to achieve here, but if you've used netflix or blockbuster, you know what happens when you update your que of movies.
I want to do something similar. Very simular. just instead of movies, I want to update my job priority list online.
I am trying to create a tool for myself that displays jobs that I am currently working on so other co-workers can see what I am working on and the priority of each job.
I have a column that displays priority for those jobs. Now as some of you know...stuff you are working on might change in priority day to day, so if I want to update (via form) a job in the priority column from say (2) to (1) that is easy, but the job that was previously priority (1) should now become (2). This is the part I am having trouble with.
Anybody know how to do this? I am using php and MySQL.
I saw an example of how to do this in PostgreSQL.
[phpfreaks.com...]
Is this the only way to do this or is there an easier way?
...but the job that was previously priority (1) should now become (2).
...and the job that was previously priority (2) should become priority (3)... and so on? Do you only ever have 1 job allocated to any 1 priority? ie. You never have two priority (2)'s?
I don't see how the link you give relates to this problem? But I may be missing something.
It sounds like you are looking for a SQL answer(?) Maybe the Database forum might be a better place to post your query...
[webmasterworld.com...]
