Performance anxiety?

Me and my partner haven't been together long and things are just starting to get sexual, we've had sex a couple of times and we've both been quite drunk which is what I put him going floppy down to but the other day we hadn't had a drink and just as he was about to put it in he went floppy. What can I do to 'help him'?