connect_error) { die("Connection failed: " . $conn->connect_error); } // start for the banner add counting and getting from table $key = "TLE-LBtrans"; $sql2 = "SELECT * FROM banner_ups3 where ROS = 'yes' ORDER BY RAND()"; $result2 = $conn->query($sql2); $hhh = 0; $hzz = 1; echo '
'; // banner rotating section while($row = mysqli_fetch_array($result2)) { $links = substr('' . $row['picture']. '', 0, 4); // echo $links; if ($links == 'http'){ if ($hhh == 0 && $hzz < 3) { echo '
Product Image

'; $adBann01 = $row['id']; $hhh++; } elseif ($hhh < 3 && $hzz < 3){ echo '
Product Image

'; $adBann03 = $row['id']; $hzz++; $hhh++; } elseif ($hzz < 3) { echo '
Product Image

'; $adBann02 = $row['id']; $hzz++; $hhh = 1; } } else { if ($hhh == 0 && $hzz < 3) { echo '
Product Image

'; $adBann04 = $row['id']; $hhh++; } elseif ($hhh < 3 && $hzz < 3){ echo '
Product Image

'; $adBann06 = $row['id']; $hzz++; $hhh++; } elseif ($hzz < 3) { echo '
Product Image

'; $adBann05 = $row['id']; $hzz++; $hhh = 1; } } } echo '
'; ?>