All I do is connect my Canon zr60 via Firewire and open up iMovie then import through it. Then I edit my movie in iMovie and share it to iDVD where I then burn a copy of it. If you have a digital video camera it shouldn't be a problem. If you don't, then sorry, I'm no help.
If you're unsure if your camera is digital or not, a digital camera uses Mini-DV tapes (small and expensive little monsters) and I've never seen a digital video camera without at least a 4-pin Firewire connector.
Well, if your camera doesn't have firewire or 4 pin firewire (i-Link). Then you will need a capture box which will set you back roughly $200 - $300 so you would probably be better off buying a new camera for $400 because if your old camera doesn't have firewire then it is likely to be crappy.