query($sql);
$person = $result->fetch_assoc();
return $person['nickname'] ? $person['nickname'] : $person['first_name'].' '.$person['last_name'];
}
function printFlier($data) {
$size = getimagesize($data['picture']);
$size_att = $size[3];
echo '';
echo '
';
echo $data['description'] ? '
'.$data['description'].'
' : '';
if($data['designer'] || $data['photographer'] || $data['model']) {
echo '
';
if($data['designer']) {
echo '- Designer: ';
echo getPerson($data['designer']);
echo '
';
}
if($data['photographer']) {
echo '- Photographer: ';
echo getPerson($data['photographer']);
echo '
';
}
if($data['model']) {
echo '- Model: ';
echo getPerson($data['model']);
echo '
';
}
echo'
';
}
echo '
';
if($front['picture']) {
printFlier($front);
}
if($back['picture']) {
printFlier($back);
}
echo '
';
// display bottom controls
displayControls($current, 'fliers.php', 'bottomctrl');
} else {
echo '>> Flyers <<
';
listEvents('fliers.php');
}
//include bottom
include_once('bottom.php');
?>