prepare("SELECT * FROM games"); $placeq->execute(); $itemp = $placeq->fetch(PDO::FETCH_ASSOC); $userq = $db->prepare("SELECT * FROM users"); $userq->execute(); $users = $userq->rowCount(); $placeq = $db->prepare("SELECT * FROM games"); $placeq->execute(); $shirtq = $db->prepare("SELECT * FROM catalog WHERE type='shirt'"); $shirtq->execute(); $itemss = $shirtq->rowCount(); $pantsq = $db->prepare("SELECT * FROM catalog WHERE type='pants'"); $pantsq->execute(); $itemsp = $pantsq->rowCount(); $adminsq = $db->prepare("SELECT * FROM users WHERE USER_PERMISSIONS='Administrator'"); $adminsq->execute(); $admins = $adminsq->rowCount(); ?>