| Representative Calendars Click Project Name to view details
|
";
}else{
$count = mysql_num_rows($task);
if($count < 1){
echo("
-- No Projects");
}else{
echo("
-- $count Projects");
while($row = mysql_fetch_array($task)){
$ProjID = $row['ID'];
$Project_Name = $row['Project_Name'];
$tusrn = $row['usrn'];
$CID = $row['CID'];
$contact = $row['contact'];
$product = $row['product'];
$prod_break = nl2br($product);
$action = $row['action'];
$note = $row['note'];
$not = substr($note, 0, 100); ;
$status = $row['status'];
$due = $row['due'];
$chunk_due = chunk_split($due, 2, ':');
$chunk_arrd = explode(":", $chunk_due);
$duem = $chunk_arrd[2].'/'.$chunk_arrd[3].'/'.$chunk_arrd[0].$chunk_arrd[1];
$dtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arrt = explode(":", $chunk_dtnum);
$dtem = $chunk_arrt[2].'/'.$chunk_arrt[3].'/'.$chunk_arrt[0].$chunk_arrt[1];
echo("" .
"" .
"" .
"" .
"" .
"" .
"");
}
}
}
echo("
|
|
| $value");
$task = @mysql_query("SELECT ID,Project_Name,usrn,CID,contact,product,action,note,status,due,dtnum FROM task WHERE usrn='$value' AND status !='Closed' ORDER BY due");
if(!$task){
echo " |
| Could not get Calendar for $value" . mysql_error() . " |
| " .
"$Project_Name | Opened: $dtem | Due: $duem | Status: $status |
| Products: $prod_break | Contact: $contact | Note: $not... |
");
}
?>
