addDataParam('i', $release_id); } elseif ($artist_id) { $join = 'INNER JOIN mkt_program mp ON mpi.mkt_program_id = mp.mkt_program_id'; $where .= 'AND mpi.info_for = "artist" AND mpi.info_for_id = ?'; $data_Params->addDataParam('i', $artist_id); } elseif ($v_id) { $join = 'INNER JOIN mkt_program mp ON mpi.mkt_program_id = mp.mkt_program_id'; $where .= 'AND mpi.info_for = "vendor" AND mpi.info_for_id = ?'; $data_Params->addDataParam('i', $v_id); } $sql = $select . $join . $where . $order; $result = $wrapperObj->executeQuery($sql, $data_Params); if ($result === false) { showierror($sql); } ?>
| Description | Info-point For | Info-point Type | Date Uploaded | Attachment | if (count($result)) { $rci = 0; foreach ($result as $row) { if ($row['info_for'] == 'project' && $row['program_name'] == 'Marketing Highlights') { continue; } $row_class = (++$rci & 1) ? '' : 'alt'; ?> | |
|---|---|---|---|---|---|---|
| =( (strlen($row['description']) > 100) ? substr(strip_tags($row['description']), 0, 100) . '...' : htmlspecialchars_decode($row['description']) )?> | =ucwords($row['info_for'])?> | =$row['program_name']?> | =format_date($row['date_added'])?> | if ($row['attachment'] == 'Y') { $varDir = '../../assets/program_info/'; if ($dh = @opendir($varDir)) { while ($file = readdir($dh)) { if (substr($file, 0, strrpos($file, '.')) == $row['mkt_program_info_id']) { echo 'View'; break; } } closedir($dh); } } else { echo 'None'; } ?> | View | &program_info_id==$row['mkt_program_info_id']?>')">Delete |
| No marketing program info found. | ||||||