Untitled

Handling numerical lists in php and MySQL
Id | position | person
======================
1  | 3        | John
2  | 1        | Jane
3  | 4        | David
4  | 2        | Emily

...order by position, person

for i in new pos+1..old pos
    pos[i]++

SET @position = 0;
UPDATE calendar_events SET position = @position := @position + 1
WHERE position >= 0
ORDER BY position, IF(calendar_event_id = 7, 0, 1), name