loadConfig($ro_config);
$sql = "SELECT count(tig.id) as total_ig FROM track_instant_grat tig
INNER JOIN track t ON t.id = tig.unique_track_id
INNER JOIN customer_master_master cmm ON tig.customer_master_master_id = cmm.customer_master_master_id
WHERE tig.active = 'Y' AND t.upc =".$upc;
$stmt = $art_db->getConnection()
->prepare($sql);
if(!$stmt->execute()){
$logger->error("Error in executing Mysql Query : $sql");
}
$igResults = $stmt->fetch();
?>
| Instant Grat or PreRelease Campaigns |
|