Notes:
|
$listemc = @mysql_query("SELECT CID,Notes,dtnum FROM con_notes WHERE CID='$ID' ORDER BY dtnum");
if (!$listemc) {
die(' Error retrieving Notes from data base. ' . 'Error: '. mysql_error(). ' ');
}
while($rowc = mysql_fetch_array($listemc)){
$CID = $rowc[0];
$Notes = $rowc[1];
$dtnum = $rowc[2];
$chunk_dtnum = chunk_split($dtnum, 2, ":");
$chunk_arr = explode(":", $chunk_dtnum);
echo("$chunk_arr[2]-$chunk_arr[3]-$chunk_arr[0]$chunk_arr[1] - $Notes ");
}
?>
|
List for Email Marketing Program -
Activity Report
$listemb = @mysql_query("SELECT ID,act_year,act_month,act_day,contact_type,act_respond,dtnum FROM con_activity WHERE CID='$ID'");
if (!$listemb) {
die('Error retrieving data from data base. ' . 'Error: '. mysql_error(). ' ');
}
while($rowb = mysql_fetch_array($listemb)){
$act_ID = $rowb[0];
$act_y = $rowb[1];
$act_m = $rowb[2];
$act_d = $rowb[3];
$act_type = $rowb[4];
$act_resp = $rowb[5];
$dateup = $dtnum[6];
echo("~ $act_m-$act_d-$act_y : $act_type : $act_resp ");
}
$listemc = @mysql_query("SELECT ID,CID,react_year,react_month,react_day FROM con_reactivity WHERE CID='$ID'");
if (!$listemc) {
echo('Error retrieving data from data base. ' . 'Error: '. mysql_error(). ' ');
}
$num_rows = mysql_num_rows($listemc);
if($num_rows < 1){
$act_flag = " ";
}else{
$act_flag = " ";
$rowc = mysql_fetch_row($listemc);
$RID = $rowc[0];
$CID = $rowc[1];
$ract_y = $rowc[2];
$ract_m = $rowc[3];
$ract_d = $rowc[4];
if($ract_y == 0){
$ract = 'ASAP';
}else{
$ract = $ract_m.'-'.$ract_d.'-'.$ract_y;
}
echo("$act_flag~ $ract " .
" " .
" ");
}
?>
|