"); include ($footer); die(); } else { //We need to proceed with the webpage displaying a closeup of the photo requested... $query = "SELECT shortName, altText, description FROM furniturePhotos WHERE photoId=$pid"; $result = mysql_query($query); $row = mysql_fetch_array($result); $photo_url = FURNITURE_QUALITY_PATH . $row['shortName'] . '.jpg'; echo ''; echo ''; echo "\n" . '

'; echo '

'; echo ''; echo $row['description']; echo '

'; echo "\n" . ' ' . "\n"; //New line //Determine the appropriate size for the picture list($width, $height) = getimagesize($root . $photo_url); if($height > $width) { $displaywidth = 450; } else { $displaywidth = 650; } echo '

' . '

'; echo "\n" . ' ' . "\n"; //New line //Add link back to the original album echo ''; echo ''; echo 'Clear here to return to the photo album'; echo '' . ''; echo "\n" . ' ' . "\n"; //New line echo '

'; } } else { //If we're here, then the pid was not set //We need to show all the pictures //Our chore is to create a dynamic table //Start by getting our query results $query = "SELECT photoId, shortName, altText, description, hasPreview FROM furniturePhotos ORDER BY position ASC"; $result = mysql_query($query); $num_of_photos = mysql_num_rows($result); $mod_answer = $num_of_photos % 3; if($mod_answer == 2){ $howmanytimes = 1; } elseif($mod_answer == 1){ $howmanytimes = 2; } else{ $howmanytimes = 0; } //Give instructions echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

The furniture gallery contains pictures of hutches, tables, beds, nightstands and many other custom pieces of work. For a closer look, just click on any particular preview. If you would like to view the photo gallery containing kitchen and bathroom cabinets, just click here.

'; //Create the table echo ''; echo ''; echo ''; while($row = mysql_fetch_array($result)){ echo "\n" . ' '; echo "\n"; echo ''; if(($index+1)%3 == 0){ //Create new rows as needed echo "\n" . ' ' . "\n"; //Blank line echo ''; echo ''; } //Increase our counter $index++; } for ($i=0; $i<$howmanytimes; $i++){ echo "\n" . ' ' . "\n"; //Blank line echo ''; } //Close our table echo "\n" . ' ' . "\n"; //Blank line echo ''; echo "\n"; echo ''; echo "\n"; echo '

'; echo "\n"; #Determine the URL to our photo if ($row['hasPreview'] == 1){ //We will use the preview picture for the photo gallery $photo_url = FURNITURE_PREVIEW_PATH . $row['shortName'] . '.jpg'; } else { //Use the full quality picture $photo_url = FURNITURE_QUALITY_PATH . $row['shortName'] . '.jpg'; } #Set our alternative (mouse over) text for the photo //If the altText field is null, we use the description if ($row['altText']){ $alt_text = $row['altText']; } else { $alt_text = $row['description']; } #Create the cell's contents... echo ''; echo "\n"; echo ' '; echo "\n"; //new line echo '
'; echo "\n"; echo '' . $row['description'] . ''; echo '

' . "\n" . '' . "\n" . '

'; } mysql_close($dbc); include ($footer); ?>