Down with the doggy style

My boyfriend and I have been going out for a year and are really in love. We started to have sex a few months ago and everything was going great until we tried doggy style. When we did it, it hurt a lot; it actually hurt so much that my knees buckled....