Re: Need a good trainer for nights...spam away :)
I'd recommend Happy Heinys pocket trainers, Super Undies nighttime undies or Mother-ease Bedwetter pants.
Lots of other more diaper-like options but those may require your help to put on/off. Some kids do manage with one-piece options like pockets (FB L or XL) or AIOs as long as they're fairly loose but no guarantee there. Of course the advantage to the diaper option is that they'll usually be less expensive and sometimes they're more reliable (in terms of preventing leaks).