<?php
										// 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 * FROM banner_ups WHERE active='yes' ORDER BY RAND()";
											$result = $conn->query($sql);									
									
										// banner rotating section
											while($row = mysqli_fetch_array($result)) {
													echo "<a href='https://landscapearchitect.com/" . $row[web] . "' target='_blank'><img width='80%' src='https://landscapearchitect.com/banner/" . $row[picture] . "' alt='' /></a>
										<br>";
											}
?>
