<?

include("connect3.inc");


$banName = $_GET['ad'];

	if ($banName == 1300) { /* Fencing */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '1300' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "Fencing2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Fencing3.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = "Fencing3.jpg";
					$picBanLink3 = "#";					

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "Fencing1.jpg";
					$picBanLink = "#";
					$picBan2 = "Fencing2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Fencing3.jpg";
					$picBanLink3 = "#";					

			}		
		
		
	} elseif ($banName == 32) { /* Lighting/Electrical */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '32' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "Lighting2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Lighting3.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = "Lighting3.jpg";
					$picBanLink3 = "#";					

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "Lighting1.jpg";
					$picBanLink = "#";
					$picBan2 = "Lighting2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Lighting3.jpg";
					$picBanLink3 = "#";					

			}				
		
	} elseif ($banName == 1214) { /* Outdoor Living */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '1214' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "Outdoor1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Outdoor21.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = "Outdoor2.jpg";
					$picBanLink3 = "#";					

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "Outdoor1.jpg";
					$picBanLink = "#";
					$picBan2 = "Outdoor2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Outdoor1.jpg";
					$picBanLink3 = "#";					

			}						
		
		
	} elseif ($banName == 38) { /* PMBR */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '38' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "PMBR1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "PMBR2.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = "PMBR2.jpg";
					$picBanLink3 = "#";					

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "PMBR1.jpg";
					$picBanLink = "#";
					$picBan2 = "PMBR2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "PMBR1.jpg";
					$picBanLink3 = "#";					

			}								
		
		
	} elseif ($banName == 29) { /* Site Amenities */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '29' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "SiteAmenities1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "SiteAmenities1.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = "M2399LB1807.jpg";
					$picBanLink = "https://landscapearchitect.com/research/Ad-Transfer/transfer/M2399LB1807AdTrans.html";
					$picBan2 = "F24967LB1807.jpg";
					$picBanLink2 = "https://landscapearchitect.com/research/Ad-Transfer/transfer/F24967LB1807AdTrans.html";
					$picBan3 = "SiteAmenities1.jpg";
					$picBanLink3 = "#";						

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "SiteAmenities1.jpg";
					$picBanLink = "#";
					$picBan2 = "SiteAmenities1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "SiteAmenities1.jpg";
					$picBanLink3 = "#";					

			}								
				
		
	} elseif ($banName == 1301) { /* Sculpture/Art/Garden Ornaments */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '1301' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "sculpture1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "sculpture2.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = "sculpture2.jpg";
					$picBanLink3 = "#";					

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "sculpture1.jpg";
					$picBanLink = "#";
					$picBan2 = "sculpture2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "sculpture1.jpg";
					$picBanLink3 = "#";					

			}								
						
		
	} elseif ($banName == 1215) { /* Site Furnishings & Receptacles */
		
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '1215' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "SiteFurnishings1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "SiteFurnishings1.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = "SiteFurnishings1.jpg";
					$picBanLink3 = "#";					

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "SiteFurnishings1.jpg";
					$picBanLink = "#";
					$picBan2 = "SiteFurnishings1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "SiteFurnishings1.jpg";
					$picBanLink3 = "#";					

			}								
				
		
	} elseif ($banName == 33) { /* Park & Recreation */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '33' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}		

			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "Park1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Park2.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = "Park2.jpg";
					$picBanLink3 = "#";					

				}				
				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "Park1.jpg";
					$picBanLink = "#";
					$picBan2 = "Park2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "Park1.jpg";
					$picBanLink3 = "#";					

			}								
						
		
	} elseif ($banName == 41) { /* Water Features */
		
		$sql899 = "SELECT * FROM banner_ups WHERE product = '41' AND ROS = 'lad'";

	 	$result899 = $conn->query($sql899);
		
		$rowcount899=mysqli_num_rows($result899);
		
		
					if (empty($rowcount899)) {
						$rowcount899 = 4;
					}			
		
		
			if ($rowcount899 == 1){

				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = "WaterFeatures1.jpg";
					$picBanLink2 = "#";
					$picBan3 = "WaterFeatures2.jpg";
					$picBanLink3 = "#";					

				}
				
			} elseif ($rowcount899 == 2){
				
				
					$picBan = "T158421LB1807.jpg";
					$picBanLink = "https://landscapearchitect.com/research/Ad-Transfer/transfer/T158421LB1807AdTrans.html";
					$picBan2 = "W3947LB1807.jpg";
					$picBanLink2 = "https://landscapearchitect.com/research/Ad-Transfer/transfer/W3947LB1807AdTrans.html";
					$picBan3 = "WaterFeatures2.jpg";
					$picBanLink3 = "#";					

				
			} elseif ($rowcount899 == 3){
				
				while($row = mysqli_fetch_array($result899)) {
				
					$picBan = $row['picture'];
					$picBanLink = $row['web'];
					$picBan2 = $row['picture'];
					$picBanLink2 = $row['web'];
					$picBan3 = $row['picture'];
					$picBanLink3 = $row['web'];					

				}				
				
			} elseif ($rowcount899 == 4) {
				
					$picBan = "WaterFeatures1.jpg";
					$picBanLink = "#";
					$picBan2 = "WaterFeatures2.jpg";
					$picBanLink2 = "#";
					$picBan3 = "WaterFeatures2.jpg";
					$picBanLink3 = "#";					

			}
		
	} elseif ($banName == 1209) {
		
		$picBan = "EquipmentInstallation1.jpg";
		$picBanLink = "#";
		$picBan2 = "EquipmentInstallation2.jpg";
		$picBan3 = "EquipmentInstallation3.jpg";
		
	} elseif ($banName == 1210) {
		
		$picBan = "EquipmentMaintenance1.jpg";
		$picBanLink = "#";
		$picBan2 = "EquipmentMaintenance2.jpg";
		$picBan3 = "EquipmentMaintenance1.jpg";
		
	} elseif ($banName == 1211) {
		
		$picBan = "tools1.jpg";
		$picBanLink = "#";
		$picBan2 = "tools2.jpg";
		$picBan3 = "tools1.jpg";
		
	} elseif ($banName == 28) {
		
		$picBan = "Lighting1.jpg";
		$picBanLink = "#";
		$picBan2 = "Lighting2.jpg";
		$picBan3 = "Lighting3.jpg";
		
	} elseif ($banName == 30) {
		
		$picBan = "Lighting1.jpg";
		$picBanLink = "#";
		$picBan2 = "Lighting2.jpg";
		$picBan3 = "Lighting3.jpg";
		
	} elseif ($banName == 1212) {
		
		$picBan = "Lighting1.jpg";
		$picBanLink = "#";
		$picBan2 = "Lighting2.jpg";
		$picBan3 = "Lighting3.jpg";
		
	} elseif ($banName == 1002) {
		
		$picBan = "Lighting1.jpg";
		$picBanLink = "#";
		$picBan2 = "Lighting2.jpg";
		$picBan3 = "Lighting3.jpg";
		
	} elseif ($banName == 1213) {
		
		$picBan = "Lighting1.jpg";
		$picBanLink = "#";
		$picBan2 = "Lighting2.jpg";
		$picBan3 = "Lighting3.jpg";
		
	}

?>