accepting credit cards

Hello everyone, I know this has been discussed many times before. I even read the past threads in the list archives. I've written a shopping cart/catalog that uses mysql on the backend. I need to be able to accept cc orders. Is Paypal a good choice? I've never really use any service like this before. When the user orders an item, will they have to leave my website? Thanks, Tyler