I have a lot of movies on my HDD all using different codecs DivX, Xbid, MPG2 etc and i want to turn them into DVD movies.
What is the best software to use?
Have a read of the AVI to DVDR tutorial, it will convert your DivX and Xvid movies to DVDR for you. It uses CCE.
See the SVCD to DVDR Tute for MPEG2 or MPEG1 re-authoring to DVDR.