|How did you determine your drive is bad?|
You can use either IDE or SATA. IMO IDE is a better choice at this time. I personally have had trouble getting SATA optical drives working on some systems.
Depending on the color you can find a fair amount of choices. Some with free shipping. I recommend ordering from newegg.com. Best online vendor there is.
Below is a complete list of all their combination CD/DVD burners. Both SATA and IDE. There is no speed advantage with SATA optical as the speed limitation on optical drives is 66mbps with both types. You do need to use an 80 wire IDE cable to get those speeds. That is the cable with the colored board end connector (usually blue).
I am partial to Lite On brand but most all are good. Look for what, if anything may be bundled with the drive. There are pictures accompanying the product that show. You may get only the bard drive or possibly cables and a burning program.
Double click on the product line to expand and you will see both product spec and rating buttons.