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

'; $hh++; } elseif ($hh < 3 && $hz < 3){ echo '
Product Image

'; $hz = 1; $hh = 0; } elseif ($hz < 3) { echo '
Product Image
'; $hz++; $hh = 1; } } else { if ($hh == 0 && $hz < 3) { echo '
Product Image

'; $hh++; } elseif ($hh < 3 && $hz < 3){ echo '
Product Image

'; $hz = 1; $hh = 0; } elseif ($hz < 3) { echo '
Product Image
'; $hz++; $hh = 1; } } } echo '
'; ?>