Book 6 Chapter 4

XHTML Files

• queryDemo.html An easy tool for viewing the queries in this chapter

PHP Files

• showQuery.php source Given a query from queryDemo, passes the query to the database and displays the results.
• showDetails.php source A multi-pass query to display an inner join. Because freeHostia does not (yet) support PHP5, I've supplied an alternate version that does not use views.
• showDetailsm4.php source A version of showDetails optimised for MySQL 4

CSS Files

• showQuery.css

SQL Files

• showHero.sql Basic select of hero table
• now.sql Result of NOW() function
• dateDiff.sql Determining date (in days) using DATEDIFF()
• years.sql Using arithmetic to convert datediff to years
• date.sql Converting days to a date
• yearMonth.sql Converting date to years and months
• concat.sql Concatenating years and montsh
• heroAgeView.sql Determining the age of the hero
• showMission.sql SELECT dump of mission table
• cartesian.sql Cartesian join of hero and mission
• innerJoin.sql Inner join of hero and mission
• heroMission.sql Hero / mission join
• showPower.sql SELECT of power table
• showHero_power.sql Hero / power join
• manyMany.sql Many - to - many join
• buildHero4.sql Script to build complete hero database (including joins and views