[GENERAL] Auto Ordering

[Shawn T. Walker]

Hi All,

I have a table of questions  to be displayed to the user.  

Table: questions
question_id SERIAL
page int
order int
question varchar(100)
answers text

The field order is how the questions are sorted.  How can I change change
question 5 to be number one and have all the other questions re-order
themselves?

Thanks in advance.
Shawn

-------
Shawn T. Walker      <--->   [EMAIL PROTECTED]





************