
Try this book. it is phenomenal. Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites http://www.amazon.com/Learning-MySQL-JavaScript-Step---Step/...
After you are done with that, try this book: PHP and MySQL Web Development http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dst...
And after you are done with it. Beef up your css with this one:CSS Mastery: Advanced Web Standards Solutions http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dst...
Once you are done with that, get your jQuery groove on with this: jQuery: Novice to Ninja http://www.amazon.com/jQuery-Novice-Ninja-Earle-Castledine/d...
then you can go on to jQuery cookbook and Professional JavaScript for Web Developers
Personally I love ruby for rails (ror) rather than php. But for development/sys admin and the developer community, I would stick with php. I have used cakephp which is ok. Not like RoR (which I pine for). But the development community is much nicer. If you decide to learn RoR go with: Head First Rails and Agile Web Development with Rails. There are some others that I have not read but are have good reviews in Amazon.
Oh yeah - stay away from Dreamweaver. What a piece of crap.
CSS Mastery: http://www.cssmastery.com/
Bulletproof Web Design http://astore.amazon.com/simplebits-20/detail/0321509021
Web Standards Solutions: The Markup and Style Handbook http://astore.amazon.com/simplebits-20/detail/1430219203
Handcrafted CSS http://handcraftedcss.com/
It would be worth to check out some about HTML5:
Brief but good introduction: http://books.alistapart.com/products/html5-for-web-designers
Also: http://introducinghtml5.com/ and http://diveintohtml5.org/
If you can afford the time and expense, a one-day Carson Workshop from a CSS master can help a lot. This one is already past, but for example: http://carsonworkshops.com/design-dev/clarke/14May2008.html
For off-the-web inspiration, study Edward Tufte (http://www.edwardtufte.com), architecture (for example, Christopher Alexander: http://en.wikipedia.org/wiki/Christopher_Alexander), and cartography (peruse a great atlas like The Atlas of Oregon: http://geography.uoregon.edu/infographics/projects/atlasPrin...).