Thanks everyone for the nice sentiments. Taking him to the vets soon, he's in too much pain.
He's been wailing all night and he can hardly walk now. I'm going to find it really hard to stay strong at the vets but I was there when we went to pick him up and I want to be with him when he passes.