Purchase a product called Cystex, which not only eases pain and burning but also contains an antibacterial to help the infection from getting worse before you are able to see your doctor. You can purchase the dual-system (liquid and tablets) from your local drugstore, Walmart, etc. Please make an appointment with your healthcare provider because "home remedies" are only a band-aid and the infection will only get worse. Instead of a minimal doctor's visit bill, you will have a expensive hospital bill. Feel better soon!
Stay away from anything with sugar in it and even diet soda, it will make it hurt more. Drink lots of water, I know you don't want to, but you have to flush it out. Of course you also need to go to the doctor and get some antibiotics, really important, you don't want it to move into your kidneys.
Urinary tract infections are treated using antibiotics that can be purchasedover the counter. soem of the drugs that you can take include Sulfamethoxazole-trimethoprim,
Amoxicillin,Nitrofurantoin or Ciprofloxacin. Cranberry juice is also very effective.