reorder records in database

[afan pasalic <afan@xxxxxxxx>]

hi,
I have a table with tasks. column "status" could be 1 (means "todo") and
0 (meas "done").
also,have column "order_no" to sort tasks by priorities.
once in a while order_no is not "in order", e.g 1, 2, 3, 5, 6, 8, 11,
12, 13, 19, 20,... (some numbers are missing).

is there built in function to "reset" order_no or I have to create php
script for it?

thanks for any help.

-afan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx