If you have a PS3, then you need wi-fi or an ethernet cable to connect to the PS, so you can access the internet. You then need to sign up for the play station network when you are connected. Then got to multiplayer from the main menu.
If you are playing on a PC then you do not need a playstation network account. Just connect to the internet and go to multiplayer from the main COD menu.