So Confused

Took 2 at home pregnancy tests and both were positive but the urine test at the doctors office was a negative. I’m so confused. My Fiancé and I were so happy as we watched two lines form on the pregnancy test. I just don’t understand. My period is 5 days late, my breasts are sore but no baby detected. I am so hurt.