if ($PagePic or $PageCat) {
try {
$sql = "SELECT DISTINCT links.id, links.name, links.img, links.url
FROM links
LEFT JOIN linkXref ON links.id = linkXref.link";
if ($PagePic) {
$sql .= " LEFT JOIN pictureXref ON linkXref.category = pictureXref.category ";
$sql .= " WHERE pictureXref.picture = :picture";
} else {
$sql .= " LEFT JOIN categories ON categories.id = linkXref.category ";
$sql .= " LEFT JOIN categoryXref ON categoryXref.related = categories.id";
$sql .= " WHERE categories.id = :category OR categories.parent = :category OR categoryXref.category = :category";
}
$sql .= " ORDER BY RAND() LIMIT 0,3";
$STH = $DBH->prepare ( $sql );
if ($PagePic) {
$STH->bindValue (':picture', $PagePic, PDO::PARAM_INT);
} else {
$STH->bindValue (':category', $PageCat, PDO::PARAM_INT);
}
$STH->execute ();
if ($STH->rowCount() > 0) {
?>
|
|
while ( $row = $STH->fetch ( PDO::FETCH_ASSOC ) ) {
$LinkName = htmlSpecialChars(stripslashes($row['name']));
$LinkImg = stripslashes($row['img']);
$LinkURL = stripslashes($row['url']);
?>
 |
}
?>
|
}
} catch(PDOException $e) {
LogFatalError($e);
}
}
?>
all pictures © Nigel Clark |
|
|
if ($PageNav) {
if ($PageDesc) {
$PageDesc = " " . $PageDesc;
}
if (!$PageIcon) {
$PageIcon = "FolderOpen";
}
?>
 |
Home : : 1999Photos from the 1999 season |
|
} ?>
if ($errMessage) { ?>
} else { ?>
} ?>
|