Next time you don’t know what to say to a friend in need, perhaps try one of these:

I GET WHAT YOU’RE SAYING.
That sounds rough, thank you for telling me.
Is there anything I can do?
I hear you.
I know it feels rough right now, but you will get through this.
No, you’re GREAT.
Remember, things feel like this sometimes… it’s not forever.
Have faith; I know you can handle this.
I get you!
You got this.
I got your back.
Would you like some chocolate?
How about some wine?
Think you have time for a hot bath anytime soon?
I hear you, and I’m sorry.
I get that, but I also know it will be okay.
I believe in you!

“Calm Upset People with Empathy, Attention and Respect” (“E.A.R. Statements” at mediate.com).  
eg:
EMPATHY: “I can hear how upset you are.”
ATTENTION: “Tell me what’s going on.”
RESPECT: “I respect your efforts.”