showDetails.php

hero

Binary Boy

mission

Make the world safe for Binary representation

villain

Octal

plot

Eliminate the numerals 8 and 9

powers

• Hexidecimation Beam
• obfuscation

Notes

This version is optimized for MySQL 4 with no views.

Hero - mission query

SELECT 
  hero.name AS 'hero',
  mission.description AS 'mission',
  mission.villain AS 'villain',
  mission.plot AS 'plot'
FROM hero, mission
WHERE
  hero.missionID = mission.missionID;
AND
  hero.name = '$hero'

Hero - power query

SELECT
  power.name AS 'power'
FROM
  hero, power, hero_power
WHERE 
  hero.heroID = hero_power.heroID
AND
  power.powerID = hero_power.powerID
AND
  hero.name = '$hero'