connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// start for the banner add counting and getting from table
$sql = "SELECT * FROM banner_ups_new WHERE ROS LIKE 'yes' AND product IS NULL AND picture IS NOT NULL ORDER BY RAND()";
$result = $conn->query($sql);
// banner rotating section
while($row = mysqli_fetch_array($result)) {
$banCount = $row['Views'];
echo $row['id'] . ' ' . $row['Views'] . '
';
?>
$link = mysqli_connect("localhost", "land_patchew", "59q2GB6k$3", "land_landscap_lollive");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "UPDATE subscribe SET first_name = '" . $first_name . "', last_name = '" . $last_name . "', comp_name = '" . $comp_name . "', address = '" . $address . "', city = '" . $city . "', state = '" . $state . "', zip = '" . $zip . "', phone = '" . $phone . "', fax = '" . $fax . "', email = '" . $email . "', month = '" . $month . "', opt_inla = '" . $opt_inla . "', opt_inlc = '" . $opt_inlc . "', opt_intle = '" . $opt_intle . "', opt_ineb = '" . $opt_ineb . "' WHERE id='" . $id . "'"; $link = mysqli_connect("localhost", "land_patchew", "59q2GB6k$3", "land_landscap_lollive");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "UPDATE subscribe SET first_name = '" . $first_name . "', last_name = '" . $last_name . "', comp_name = '" . $comp_name . "', address = '" . $address . "', city = '" . $city . "', state = '" . $state . "', zip = '" . $zip . "', phone = '" . $phone . "', fax = '" . $fax . "', email = '" . $email . "', month = '" . $month . "', opt_inla = '" . $opt_inla . "', opt_inlc = '" . $opt_inlc . "', opt_intle = '" . $opt_intle . "', opt_ineb = '" . $opt_ineb . "' WHERE id='" . $id . "'"; $link = mysqli_connect("localhost", "land_patchew", "59q2GB6k$3", "land_landscap_lollive");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "UPDATE subscribe SET first_name = '" . $first_name . "', last_name = '" . $last_name . "', comp_name = '" . $comp_name . "', address = '" . $address . "', city = '" . $city . "', state = '" . $state . "', zip = '" . $zip . "', phone = '" . $phone . "', fax = '" . $fax . "', email = '" . $email . "', month = '" . $month . "', opt_inla = '" . $opt_inla . "', opt_inlc = '" . $opt_inlc . "', opt_intle = '" . $opt_intle . "', opt_ineb = '" . $opt_ineb . "' WHERE id='" . $id . "'"; $link = mysqli_connect("localhost", "land_patchew", "59q2GB6k$3", "land_landscap_lollive");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "UPDATE subscribe SET first_name = '" . $first_name . "', last_name = '" . $last_name . "', comp_name = '" . $comp_name . "', address = '" . $address . "', city = '" . $city . "', state = '" . $state . "', zip = '" . $zip . "', phone = '" . $phone . "', fax = '" . $fax . "', email = '" . $email . "', month = '" . $month . "', opt_inla = '" . $opt_inla . "', opt_inlc = '" . $opt_inlc . "', opt_intle = '" . $opt_intle . "', opt_ineb = '" . $opt_ineb . "' WHERE id='" . $id . "'"; $link = mysqli_connect("localhost", "land_patchew", "59q2GB6k$3", "land_landscap_lollive");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "UPDATE subscribe SET first_name = '" . $first_name . "', last_name = '" . $last_name . "', comp_name = '" . $comp_name . "', address = '" . $address . "', city = '" . $city . "', state = '" . $state . "', zip = '" . $zip . "', phone = '" . $phone . "', fax = '" . $fax . "', email = '" . $email . "', month = '" . $month . "', opt_inla = '" . $opt_inla . "', opt_inlc = '" . $opt_inlc . "', opt_intle = '" . $opt_intle . "', opt_ineb = '" . $opt_ineb . "' WHERE id='" . $id . "'";
if(mysqli_query($link, $sql)){
echo " ";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
: