Webmonkey have an excellent starter set of articles and if you look at the examples with the right eyes you'll be able to adapt them to suit other projects: click here
A nice article with sample code to download is click here
PHPfreaks have some excellent articles: click here
The mighty DevShed click here has some serious content but much of it is quite advanced.
Two extremely good books I wouldn't hesitate to suggest are:
Build Your Own Database Driven Website Using PHP & MySQL by Kevin Yank, from Sitepoint click here
PHP and MySQL Web Development 2nd Edition, by Luke Welling and Laura Thomson.
Kevin Yank's book is superb and ideal for newcomers. It centres around building a dynamic Jokes site with pages that allow people to submit jokes and other pages that allow them to be removed. It features log-in, security and alol kinds of other tricks and gives you the basics of website content management. If you apply a bit of imagination to it the principles and methods the book teach you will take you a very long way. In fact, Sitepoint has some useful articles as well on their site, so it's worth a look just to check out the tutorials, but the book is written very much for newcomers.
The second book is far more complex and takes you through all kinds of projects covering building forums, e-commerce shopping carts, user authentication and so on. It isn't for a beginner, but you should keep it in mind for future reference - it's about the best overall book on both PHP and MySQL that I've read yet.
Most other books I've read are either very specialised or they brush over a topic without giving you all the details.
Have a look at the above to get you going. If you want more post again, and good luck with it.