Basically DDR2 offers more bandwith, at a slower speed compared to DDR, which offers less bandwith but at a faster speed.
However with AMD's transition to Socket AM2 which only utilizes DDR2, and with Intel already being totally DDR2 based, DDR2 is the way of the future. Soon the DDR2 timings (or speed), will fall to the speeds of DDR (hopefully, or at least close!) and then DDR2 will have all advantages over DDR. So DDR2 is what you want.