Noxzema is also great for sunburns. I also keep a bottle of aloe vera in the fridge, the cold gel really helps to soothe a mild sunburn.
When raising my kids and cooking alot, I kept a large aloe plant in the kitchen window...just break off a 1 inch piece and rub it on the burn...takes the pain away.