How many times does it take for you to get an STD and the medicine doesnt work?

The medicine will work as long as the bacteria isn't resistant. You're more at risk from you or our partner not taking the medicine incorrectly when you have an STD than you are at risk from getting the STD multiple times.