Oh my X usto try that same crap. It's called manipulation and emotional abuse. You don't have to stand for it. He needs to grow up.
"And I want to fix it and make him feel better, becuase I can't stand when he's upset, and I think he'll drink, or cheat, because he's mad at me."
Honey, if he will drink or cheat b/c you don't make him feel better this should tell you something.