new NOW time variable; updates to mysql methods