New Notes:
Notes are dated automatically.
Notes:
Error retrieving Notes from data base. ' . 'Error: '. mysql_error(). '');
}
while($rowc = mysql_fetch_array($listemc)){
$CID = $rowc[0];
$Notes = stripslashes($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 ");
}
?>
|
Error getting quote data.
" . "Error: ". mysql_error()." ");
}else{
$numrows = mysql_num_rows($listem);
if($numrows < 1){
echo("
No Eco-\$mart Quotes");
}else{
echo("" .
"Eco-\$mart Quotes: ");
while($inv = mysql_fetch_array($listem)){
$QID = $inv[0];
$started=$inv[1];
$chunk_due = chunk_split($started, 2, ':');
$chunk_arrd = explode(":", $chunk_due);
$start = $chunk_arrd[2].'/'.$chunk_arrd[3].'/'.$chunk_arrd[0].$chunk_arrd[1];
echo("" .
"X " .
"Quote $QID - Started: $start ");
}//while getting quotes
}//there are quotes
}//got listem
mysql_select_db('ecosmar_friendly', $dbcnx);
$new = @mysql_query("SELECT ID,Project_Name,status,due FROM task WHERE usrn='$usrn' AND CID='$ID' AND status='Hot' ORDER BY due DESC");
if (!$new) {
echo("
Problem getting Hot Projects. Error: ". mysql_error());
}
$num_rows = mysql_num_rows($new);
if($num_rows > 0){
echo("" .
"Current Projects:");
while($row = mysql_fetch_array($new)){
$ProjID = $row[0];
$ProjName = $row[1];
$ProjStat = $row[2];
echo("
 " .
" $ProjName - $ProjStat");
}
}else{
$newt = @mysql_query("SELECT ID,Project_Name,status,due FROM task WHERE usrn='$usrn' AND CID='$ID' AND status='Open' ORDER BY due DESC");
if (!$newt) {
echo("
Problem getting Projects. Error: ". mysql_error());
}
$num_rows = mysql_num_rows($newt);
if($num_rows < 1){
echo("
No Open Projects");
}else{
echo(" " .
"Open Projects:");
while($row = mysql_fetch_array($newt)){
$ProjID = $row[0];
$ProjName = $row[1];
$ProjStat = $row[2];
echo("
$ProjName - $ProjStat");
}
}
}
echo(" ");
?>
|
