How do I help him?

Whenever my BF or SO or whatever needs some comfort, I never know how to help. I listen, I asked questions, I apologize, I'll even chip in my two cents time to time. It doesn't seems to work, I feel like such a failure to him. Last time I even made it worse by hurting his feelings, what can I do to be a better comfort?