Heheheheheheh....
Well, something that I actually know quite a bit about for once.
Here is a good guide for you digital photo takers...
1MP - Decent 4X6-inch prints, and thats about it.
2MP - Reasonabally good 4X6 inch prints, you could also get a 5X7 or 6X8 out of it, but it will come out like crap, and extremely mediocre 8X10/8X12 prints.
3MP - Excellent 4X6 prints, good 5X7 and 6X8 prints. Will make a decent 8X10/8X12.
4MP - Amazing 4X6, 5X7, 6X8 prints and very good 8X10/8X12 prints.
5MP and up, if you got the money, by all means go for a camera that has these resoluitions, but they are not very practical for the average picture taker.
Also, avoid digital zooms on cameras like the plague. They cause more trouble than they are worth. Optical zoom is the way to go, no matter what.
And some tips for setting up your camera, for the best possible pictures on your camera, have it at the highest resoluition setting, You can decrease the settings to fit more onto a memory card, but you lose image quality bigtime. The average user has a 3.25MP camera, and a 128mbit card wich can hold 145 images set at max resoluition which is good for most casual picture takers.