|
CLICK PROJECT NAME TO VIEW AND EDIT
|
Error: ". mysql_error());
}
$num_rows = mysql_num_rows($new);
if($num_rows == 0 or $num_rows == ""){
echo("
" .
"| No Projects due on this date. |
");
}else{
echo("
" .
"| $num_rows Projects due on this date. |
");
while($row = mysql_fetch_array($new)){
$ID = $row['ID'];
$Project_Name = $row['Project_Name'];
$usrn = $row['usrn'];
$CID = $row['CID'];
$contact = $row['contact'];
$product = $row['product'];
$produc = substr($product, 0, 40);
$notes = $row['note'];
$note = stripslashes($notes);
$not = substr($note, 0, 30);
$action = $row['action'];
$act = stripslashes($action);
$ac = substr($act, 0, 30);
$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_dt = chunk_split($dtnum, 2, ':');
$chunk_arrt = explode(":", $chunk_dt);
$dtem = $chunk_arrt[2].'/'.$chunk_arrt[3].'/'.$chunk_arrt[0].$chunk_arrt[1];
echo("
" .
"
" .
"| New: $dtem—Due: $duem—Status: $status" .
" | Contact: $contact" .
" |
" .
"
" .
"| Product: $product" .
" |
" .
"
" .
"| " .
"Action: $ac..." .
" | " .
"Note: $not..." .
" |
" .
"
----------------------------------------------
");
}
}
?>
$Project_Name" .
"