What do I tell someone who just got broken up with?

So, one of my friends got broken up with by his girlfriend of two years – I’m not sure what to say to him right now besides that I’m sorry.

His plan right now is to get drunk – and he’s been in jail once already for fighting (he lives in Denmark, so I guess that’s how their rules work or something).