Chapter 4

Note

Use the queryDemo.html program to go through the examples in this chapter. If you want to try these examples on your own system, begin with the appropriate version of buildHero.sql.

Note that I've included two versions of some of the files. The standard examples assume MySQL 5. However, a few servers are still using MySQL 4, which does not support views. If the standard version of a script doesn't work, try the other version

XHTML Files

queryDemo.html

PHP Files

showQuery.php source
showDetails.php source
showDetailsm4.php source Shows details without views (needed if your server doesn't support MySQL 5 yet.)
hero.php source

CSS Files

showQuery.css

SQL Files

buildHero.sql Use this script to build the entire example database on your system (Assumes MySQL 5)
buildHero4.sql Use this script if your server does not support MySQL 5 (Does not include views. MySQL 5 version is preferred)
showHero.sql
now.sql
dateDiff.sql
years.sql
date.sql
yearMonth.sql
concat.sql
heroAgeView.sql
showMission.sql
cartesian.sql
innerJoin.sql
heroMission.sql
showPower.sql
showHero_power.sql
manyMany.sql