PHP/MySQL : Creating a dynamic summary
Jean-Guillaume Birot


Numerous sites use the Master/Detail relationship. For instance, a summary page displays a list of short descriptions with links pointing to pages containing details. This kind of relationship is very easy to implement with PHP. This gives us the opportunity to tackle the question of processing a SQL query that returns more than one row, and to start creating a library of functions that will be useful for all your developments.

Prerequisites This workshop is based on the techniques covered in the workshop explaining the display of a MySQL database record. So have a look at it if you feel the need or if you have not visited it at all.



Contents:

- Creating a Function Library for Database Connections

- Details of the Articles

- Writing a SQL query for the Title List

- Displaying the Record List