Mike Nifong sees the handwriting on the wall (I never thought I would write that phrase) and resigns