addDataParam('s', $description);
$data_params->addDataParam('i', $mkt_program_info_id);
if ($wrapperObj->executeQuery($sql, $data_params, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) {
showierror($sql);
}
$msg = '507502ff';
header("Location: add_mkt_comments_pop.php?track_id=$track_id&cd=$cd&upc=$upc&confirm_msg=$msg");
exit();
}else{
//insert the program info for track if there is not mkt program info
$sql = 'insert into mkt_program_info(info_for, info_for_id, description, date_added, last_updated) values("track", ?, ?, now(), now())';
$data_params = new QueryData();
$data_params->addDataParam('i', $id);
$data_params->addDataParam('s', $description);
if ($wrapperObj->executeQuery($sql, $data_params, MysqliWrapper::RETURN_INSERT_ID) === false) {
showierror($sql);
}
$msg = '551a0205';
header("Location: add_mkt_comments_pop.php?track_id=$track_id&cd=$cd&upc=$upc&confirm_msg=$msg");
exit();
}
}
$sql = 'SELECT t.id, t.track_name, mpi.description, mpi.mkt_program_info_id
FROM track t
inner join mkt_program_info mpi on mpi.info_for = "track" and mpi.info_for_id = t.id
WHERE t.id = ?';
$data_params = new QueryData();
$data_params->addDataParam('i', $id);
$rs = $wrapperObj->executeQuery($sql, $data_params);
if ($rs === false) {
showierror();
}
$row = $rs[0];
$id = $row['id'];
$description = $row['description'];
$mkt_program_info_id = $row['mkt_program_info_id'];
?>