How to improve photo resolution?

May 25, 2008 2:06pm CST
I've been taking photos of my nephew using my mobile phone. And the camera only has 2.0 mega pixel resolution making the photo have some red and unclear. Is there anybody who is good in photoshop here to help me to refine the photo resolution and making the image sharp and clear as it is look like in the magazine photo. Any help would be appreciated.