0) { $code_invalid = 1; $today = date("Y-m-d H:i:s"); $phpdate=strtotime("$today"); $phpdate=strtotime('-2 hour', $phpdate); $today = date("Y-m-d", $phpdate); $query = "SELECT * FROM i2monline.px_promo_code WHERE code='$promotional_code' AND '$today'<=valid_until AND nb_times > 0"; $result = mysql_query($query); if($result) { if(mysql_num_rows($result) > 0) { $code_valid = 1; $code_invalid = 0; if($row = mysql_fetch_object($result)) { if(strlen($row->affiliate_id) > 0) { Header("Location:$PHP_SELF?code=$promotional_code&a_aid=$row->affiliate_id"); } $discount = $row->discount; } } } //if valid // deduce the price // $code_valid = 1; // else // display invalid code } } else if(isset($_GET['code'])) { $promotional_code = trim(strtoupper($_GET['code'])); if(strlen($promotional_code) > 0) { $code_invalid = 1; // check in db the code if is valid or not $today = date("Y-m-d H:i:s"); $phpdate=strtotime("$today"); $phpdate=strtotime('-2 hour', $phpdate); $today = date("Y-m-d", $phpdate); $query = "SELECT * FROM i2monline.px_promo_code WHERE code='$promotional_code' AND '$today'<=valid_until AND nb_times > 0"; $result = mysql_query($query); if($result) { if(mysql_num_rows($result) > 0) { $code_valid = 1; $code_invalid = 0; if($row = mysql_fetch_object($result)) { $discount = $row->discount; } } } //if valid // deduce the price // $code_valid = 1; // else // display invalid code } } ?>