As the title says I need some recommendations for starting up with C#. I do have minor experience with programming such as html*I do have plenty of experience with this one*, &#106avascript, vb, c+, and php but not near enough that I would call myself even an amateur programmer although I do understand most of the basics probably. So I need a beginners book most likely. What I plan on doing with C# is building websites *mainly community forums*, web apps, games, and probably some computer apps, although that last one will probably just be some remote admin controls for those that come before it. Bonus points if it gets into MYSQL since I'll need to learn that too so I can use databases. I realize that no beginners book is going to touch on all of those branches but it would be nice if talked about some. It would be nice also if it had projects that made games and such to keep me interested and awake. This probably don't need to be said but also up to date. I have no professors at my college that knows the C# language so I have nobody to go to if I have issues with legacy code which has been a issue I've had with books I've bought in the past. Thanks for your input in advance.

I found the O'Reilly "Programming C#" (I have the c# 3.0, fifth edition, but there'll be an uptodate one available) book to be a good start for c#. Much better than those "c# in 21 days/24 hours" books. A bit basic maybe for someone with a lot of programming experience, but it does touch a few topics you mentioned.

Of course, this place has a whole c# workshop forum attached, so you could check there?

.Net Framework Essentials and Programming C#