I got a 10 or 12 foot video camera to TV cable from radio shack for about 16.99.
I figured out how to get the cable to work on my own. I noticed when I plugged the colors into the matching plugs that there was a buzzing. I figured that the buzzing was from the video being plugged into one of the audio ins. Sure enough, I switched them around until it worked.
I hadn't figured out the right/left correct plugs, so thanks for that!
This is how we finished off the season of Battlestar Galactica. We don't have the sci fi channel, so I'd download the shows onto my ipod and then we'd plug it into the TV with this cable. The quality was amazing considering that it's just 320 pixels wide. Pretty much broadcast quality at worst.
This is a great tip!