Project Summary for <?= $pi->projectnumber ?>

* Copyright (C) 2005 James Grant * * This program is free software; you can redistribute it and/or * modify it under the terms of the GNU General Public * License as published by the Free Software Foundation, version 2. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; see the file COPYING. If not, write to * the Free Software Foundation, Inc., 59 Temple Place - Suite 330, * Boston, MA 02111-1307, USA. */ ?> prepare("SELECT * FROM projects WHERE projectnumber=? AND year=?"); $q->execute([$pn, $config['FAIRYEAR']]); if ($q->rowCount() == 0) { echo 'not found'; exit; } $pi = $q->fetch(PDO::FETCH_OBJ); $sq = $pdo->prepare("SELECT firstname,lastname,school FROM students LEFT JOIN schools ON schools.id = students.schools_id WHERE registrations_id=? AND students.year=?"); $sq->execute([$pi->registrations_id, $config['FAIRYEAR']]); $student = array(); while ($si = $sq->fetch(PDO::FETCH_OBJ)) { $student[] = $si->firstname . ' ' . $si->lastname; $school = $si->school; } $students = implode(' and ', $student); if (file_exists($prependdir . 'data/logo-100.gif')) $logo = '

'; else $logo = ''; ?> Project Summary for <?= $pi->projectnumber ?>

title ?>

Floor Location : projectnumber ?>

summary)) ?>