Nick,
Given the choice of either an S-video cable or a composite video (yellow cable), go with the S-video. It provides a much bigger increase in video quality over the composite. If you want to step up the quality a bit more, and your system supports it, try a pair of component video...