In another installment of his "PHP Fundamentals" series, John Coggeshall has a new piece on O'Reilly's DevCenter - MySQL Crash Course, Part 3.
[Today] I will wrap up my crash-course series on MySQL by discussing some useful functions available when using SQL and PHP, introducing a clause or two for the SELECT statement, and explaining a few of the principles behind relating one table to another (after all, it is a "relational" database system).
He builds on the foundation of his other articles (here and here) and continues on with a few more advanced SELECT queries, including joins, LIMIT, and the ORDER BY clause.
Personally, I think that anyone out there just starting with MySQL and PHP should definitely give this series a look - some of this stuff I only wish I'd had when I was starting out...




