%
include "dbaccess.php";
// Select image for index page using the HOMEPAGE field
$strHomeImageQuery = "SELECT * FROM PICTURES WHERE HOMEPAGE = 1 LIMIT 1";
$homeImageResults = mysql_query($strHomeImageQuery)
or die(mysql_error());
$homeImageRow = mysql_fetch_array($homeImageResults);
$strHomeImageFile = $homeImageRow['LARGEFILE'];
$strHomeImageMusician=$homeImageRow['FNAME']." ".$homeImageRow['LNAME'];
$strHomeImageFormat=$homeImageRow['PICFORMAT'];
// Select three thumbnails for the slide show, using the SLIDESHOW, SLIDESHOWSEQ fields
$strThumbnails = "SELECT * FROM PICTURES WHERE SLIDESHOW = 1 ORDER BY SLIDESHOWSEQ ASC LIMIT 3";
$thumbnailResults = mysql_query($strThumbnails)
or die(mysql_error());
if($thumbnailResultArray = mysql_fetch_array($thumbnailResults)){
$strThumbNailFile1 = $thumbnailResultArray['THUMBNAILFILE'];
$strThumbNailFormat1 = $thumbnailResultArray['PICFORMAT'];
}
if($thumbnailResultArray = mysql_fetch_array($thumbnailResults)){
$strThumbNailFile2 = $thumbnailResultArray['THUMBNAILFILE'];
$strThumbNailFormat2 = $thumbnailResultArray['PICFORMAT'];
}
if($thumbnailResultArray = mysql_fetch_array($thumbnailResults)){
$strThumbNailFile3 = $thumbnailResultArray['THUMBNAILFILE'];
$strThumbNailFormat3 = $thumbnailResultArray['PICFORMAT'];
}
// function to present thumbnail array
function presentThumbnails() {
global $thDirectory, $strThumbNailFile1,$strThumbNailFile2,$strThumbNailFile3;
echo "
";
}
%>
<%
header("Last-Modified: $gmdate_mod");
%>
Guy Fonck Jazz Photography - Home
Stamp Collecting World
<% if ($strHomeImageFormat == 'portrait') {
// portrait layout
%>
<% include "editwelcome.php";%>
Contact Me
Click here for the print edition of Women in Jazz
<% presentThumbnails();%>
<%} else {
// landscape layout
%>
<%}%>