Firstly, from what you say, it is unlikely you did anything to have 'ruined sex' . As skeezyks says, the key is communication and compromise. Why did he go off sex? Why did you get so upset? Being two obvious questions for you to ask him and yourself.
I have been in a sexless marriage for 14 years now (I have been with my - now - wife 18 years). She went off sex at the menopause, and I just accepted it at the time, because I loved her. Now I wish we had engaged in some honest, if painful, conversations at the time - rather than be left with the considerable frustration I feel now. While there is certainly so much more to a relationship than sex, sex IS important, as much for the intimacy as for physical satisfaction. But it needs to be mutual desire.
Sex with your partner may well not have been anything to do with it being a turn-off for him. Do not blame yourself - but do talk. And if he is unwilling to talk, perhaps ask yourself whether you would really want to be back in a relationship that is so one-sided sexually.
Good luck.