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%' ORDER BY RAND()"; $result = $conn->query($sql); $xx=1; echo "

"; // banner rotating section while($row = mysqli_fetch_array($result)) { if (!empty($row[picture]) || !empty($row[page])) { if($xx<50){ echo "

"; $xx++; } } } echo "

" ?>