My brother's mobile phone is a Nokia 6230i.
He has a few videos stored in the phone & he is wondering how to transfer these videos to his pc & then to dvd.
Could someone tell me what is the name of the lead that he needs to connect his mobile phone to his pc?

I have one of those phones and I find it's quicker (and cheaper to buy) a bluetooth dongle for your pc and then transfer stuff that way.
The cable has a wide multi-pin plug on one end (the same as the headphone connector) and a USB plug on the other, and they are much more expensive to buy than a dongle (dongles can be picked up on ebay or similar for a couple of quid delivered)