I'm looking to buy a digital camera, but haven't a clue what to get.

I'd mostly use it for photos and videos at music gigs, so it's got to be good in low level lighting, and have a good mic for picking up sound. Also, it would be good if it had pretty good optical zoom.

Thanks for any help.