<?php

													echo "<div style='position:absolute; left:800px; top -10px'>
														  <a href='https://landscapearchitect.com/research/Ad-Transfer/transfer/vendor/PavestoneADtrans.html'><img src='https://landscapearchitect.com/banner/P2693LO0414.jpg'></a>
														  <p style='line-height:8px'>&nbsp;</p>
														  <a href='https://landscapearchitect.com/research/Ad-Transfer/transfer/DreamscapeOutdoorAdTrans.html'><img src='https://landscapearchitect.com/banner/2016-V2-Web-Ad-240-x-240.jpg'></a></div>";




										// Banner Ads Start

											$servername = "localhost";
											$username = "landscap_lol";
											$password = "meow2meow";
											$dbname = "landscap_lollive";
	
										// Create connection
											$conn = new mysqli($servername, $username, $password, $dbname);
										// Check connection
											if ($conn->connect_error) {
   												 die("Connection failed: " . $conn->connect_error);
											} 


										// start for the banner add counting and getting from table

														  
											$sql = "select DISTINCT picture, web FROM banner_ups WHERE product IS NULL AND comp_name NOT LIKE '%Landscape Communications%' AND location IS NULL  ORDER BY RAND()";
											$result = $conn->query($sql);	
													$xx=1;

													echo "<div style='position:absolute; left:800px; top:490px'>";
										// banner rotating section
											while($row = mysqli_fetch_array($result)) {
													
											 	if (!empty($row[picture]) || !empty($row[page])) {
														if($xx<50){
															echo "<br><a href='" . $row[web] . "' target='_blank'><img width='240px' src='https://landscapearchitect.com/banner/" . $row[picture] . "' alt='' /></a> <span style='line-height:5px'>&nbsp;</span>";
															$xx++;
														}
												}
											}
											
											
													echo "<div style='position:relative; top:25px'>"
											
?>