Want to create PHP website utilising MySQL

Cannot find suitable information on web

[The Cricketer]

I have scanned a couple of books on php/mysql and looked at some websites. What I am looking for is a step by step tutorial which just covers producing a webpage/website where the content for the pages are gathered from a Mysql database, eg title, metatags, h1 tags + more body content. Basically a tutorial with the ins and outs whilst illustrating any common pitfalls. From beginning to end with out venturing in to more difficult areas like carts etc.

The thing is whenever I've looked for such a tutorial I just find tutorials on creating applications (eg carts, using dropdown menus to retrieve data from databases, clicking links to delete records and to add records.) What I want is probably simpler than this, I just want to make sure that i do everything right.

Can anyone lead me to a good example of a tutorial please. I've trawled google, just maybe not in the right places.

Cheers

[Robino]

The Wellington and Thomson SAMS book is pretty good. It walks you through exactly what you're looking for. And I believe it even takes you step-by-step in building a basic e-commerce cart.

PHP and MYSQL Development
ISBN#: 0-672-31784-2

[The Cricketer]

Thanks Robino, as long as there are some sections which don't focus on the commercial and true interactive aspects of php/mysql.

They think that we 'all' want to learn about logins/carts and nothing else.

Here's hoping.
Cheers

[Timotheos]

Here's a pretty simple tutorial [devshed.com] at DevShed

[Althius]

I really liked "PHP and MySQL for Dynamic Websites" by Larry Ullman.

It assumes you know little to zero PHP and zero SQL. You may have more knowledge of PHP than that, but it is set up where you can skip that section and not miss anything.

Plus the author has a forum where he answers questions you might encounter (very helpful!) I went from knowing nothing about Databases to constructing fully functional webpages that utilize PHP and mySQL in about a month.

It does put it all together at the end of the book with three fully functional example web sites. It was really nice to "put all the pieces together", and have a real life example that actually *worked*. One is user-registration, another is content management, and then finally E-commerce.