PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide I'm a big fan of the quickstart and quickpro guides by larry ulman. It's how i learnt php and mysql
I agree with for dummies series... some of good addition Head First PHP & MySQL PHP Cookbook - O'reilly Learning PHP 5 - David Sklar PHP Cookbook - David Sklar
If you're like me, just learn as you go. Think of something to make, and lookup PHP functions and syntax while you're making it. Start with a simple already made script and just develop it from there.
I'll swear by this book: PHP 6 Fast and Easy Web Development by Matt Telles and Julie C. Meloni Amazon sells it, although I bought it locally at Barnes & Noble. I like it better than the "for dummies" because there are more working examples that get you started instead of talking about concepts. You learn by doing - and there are great examples in here that you can break down and learn how they work. Once you understand them, you can experiment with modifying them, and you'll be writing your own code in no time and you'll build from there. I have the original edition and recently bought this one last year - and I found it to be even more informative and useful with this new edition. So good luck - and hope you're making cool websites in the not-to-distant future
I dont know about book, but I learn PHP from the site: PHP.NET Sometimes there are user will post useful code in the comment area