Depends what you need to do with it. Home movie or like a real film?
I'd recommend Adobe Premier for PC for a film and Adobe Premier Elements for something simpler. For Mac, I'd say go with Final Cut Pro for something advanced and either Final Cut Express HD or iMovie HD for something simpler.
Hope that helps.
-Jeff