Hi All I recently posted a question on the following
I wanted to update a table set of the order of records ie..
I have a list of cd titles that customers can buy the are members and keep a list of there favorite cds up to 20 1 being the #1 cd When the do decide to buy there favorite cds they list there first favorite 3 cd so when they purchace them there order changes now the 4th cd is in the first postion but it is still labled 4 I want to re order these numbers so the the new count would be 1 to 17 instead of 4 to 20
I know this is the same thing but it will not be user friendly when they view the list
vincent was nice enough to give me this code
UPDATE table SET order_column = order_column - 1 WHERE order_column > $removed_order_number
I just can't get it to work for me
If any body has any suggestion that would be great
TIA Richie TM
