connect(); $title = 'Master-Detail'; $main = '

'; $main .= '"; if (isset($_GET['catid'])) { $query = $db->prepare("SELECT p.name, p.price, p.shortdesc, p.image FROM geekproducts p, geekproductcategories pc WHERE pc.catid = ? AND pc.itemid = p.itemid ORDER BY p.price, p.name;"); $query->execute(array($_GET['catid'])); $catname = $db->prepare("SELECT catname FROM geekcategories where catid = ?"); $catname->execute(array($_GET['catid'])); $selection = $catname->fetch(); $selection = $selection['catname']; // Differences in PHP versions making me amend my already terrible code $number = $query->rowCount(); $isS = ($number > 1) ? 's' : ''; $main .= "

$number item$isS in category $selection.

"; foreach ($query->fetchAll() as $row) { $main .= "

$row[name]

Price: $$row[price]
$row[shortdesc]

"; } $main .= "

"; } else { $main .= "

Select a category!

"; } $main .= "

"; require '../utils/simpleTemplate.php'; ?>