How come I was so stupid? And how do I stop it happening again?

I think the best thing for you to do right now is take some time to yourself and perhaps see a counsellor to go through your feelings. Ask your g.p for a referral, i think the first 6 sessions are free. Take care.