Limp....

Last night me and my dude were doing the usual weekend stuff ( drinking and what not ) and when it was time to have sex it was like his penis went soft and wouldn’t get on hard. It was fine today having sex but last night never happened before...??? Any ideas