update by john