My Mom is having recurrent UTIs. Nothing seems to help. Any advice?

We've used antibiotics cranberry, herbs etc. She was hospitalized in April of this year due to confusion, nightmares & erratic behavior. She had a UTI. Looking back, I can see that she had quite a few of these episodes over the past 5 years she's been living with me. The worst are the night terrors.
The second hospitalization was a week after the first She was given a flouriquinoline antibiotic and she completely went demented. (one of the side effects of the drug, in the elderly, that they don't mention unless you go digging for the information) She is allergic to penicillin. She has been given Batrin, a sulfa drug, for 10 days at a stretch. That seems to help, but the infection comes back within a week to ten days and we're back to square 1. This time the crazy behavior started at the end of her round of drugs. Last night when I called her to dinner, rather than go to the table, she came behind the kitchen counter. I told her that we were eating at the table (we don't have a place to eat in the kitchen area) she went and stood at the counter. She was so confused she couldn't find the table. She's drinking cranberry juice 2 X daily. She's taking the herbal mix "Kidney Blend" She's drinking lots of water, but she has to wear "depends". Any suggestions would be appreciated.
My husband told me that when his X wife had this, they would hospitalize her and catheterize her and "flush" her bladder with an antibiotic wash.