If your IDE cable only has two connectors, then yes, you will need to buy a new cable with three connectors. One usually comes with the drive these days, even OEM drives. If not, then the following link will take you to a reseller that has what you need.
http://www.newegg.com/app/ViewProductDesc.asp?description=12-104-113&catalog=1&manufactory=BROWSE&depa=1
You can either buy it from them, or find something equivalent somewhere else since the shipping costs more than the cable, but take a look at the enlarged image so you know what you're looking for.
I have installed a dvd rom drive to my computer i have set it to master and the cd rewriter to slave i have fitted the e-ide cable but there is no connector to the rewriter do i need a new cable with extre connector and where does it go to
Please help

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic