Stem rot affects the stems of the zucchini plant, whereas root rot is a condition caused by too much water in the soil, which in turn leads to the decay of the root system.