Depends on the DVD player.

You don't connect it to the cable box... you connect it to the TV.

Good: Composite (yellow for video; white and red for audio).
Better: Component (red, green, blue...