You should be able to buy a standard SVideo cable and plug that from the SVideo Out of your video card to the SVideo in on your TV. Don't forget about the audio too, so a stereo jack to Phono cable is what you might need for the audio.
A lot of SCART sockets also have extra functions such as SVideo, RGB as well as Composite Video. Check your TV manual for what the SCARTS on the back do. If one does SVideo, you can get a little adapter to convert SVideo to Scart.
Once you have connected everything up, reboot your PC so the video card detects the TV, you should then be able to play with the settings in the video control panel . I would also advise you to update the Radeon drivers, I think they are called Catalyst Series. The Catalyst drivers will also be able to let you set up the Theatre mode and over scan for watching DVD or video playback too!
On a little note on signal quality, if you use one of them SVideo to Phono plug adapters mentioned above, you will get a reduction in signal quality. The best quality you can get would be through RGB, the next best is SVideo, then Composite Video and the worst is UHF. So try using SVideo and not Composite. It will make a heck of a difference believe me. Mind you, if you're just watching videos on the TV from the PC, then composite will be okay.
If you want any more info, just give me a shout