Sorry, there is a problem with your username. You must Log in to view this page.

"); } $today = date("F j, Y"); $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_friendly', $dbcnx); $listem = @mysql_query("SELECT ID,Project_Name,CID,product,note,action,status,due,dtnum FROM task WHERE ID='$ID'"); if (!$listem) { echo("Problem retrieving Project Data.
Error: ". mysql_error()); }else{ $project = mysql_fetch_array($listem); $ID = $project['ID']; $Project_Name = $project['Project_Name']; $CID = $project['CID']; $product = $project['product']; $prod_break = nl2br($product); $note = $project['note']; $note_break = nl2br($note); $action = $project['action']; $status = $project['status']; $due = $project['due']; $chunk_due = chunk_split($due, 2, ':'); $chunk_arrd = explode(":", $chunk_due); $due_date = $chunk_arrd[2].'/'.$chunk_arrd[3].'/'.$chunk_arrd[0].$chunk_arrd[1]; $dtnum = $project['dtnum']; $chunk_dtnum = chunk_split($dtnum, 2, ':'); $chunk_arr = explode(":", $chunk_dtnum); $note_date = $chunk_arr[2].'/'.$chunk_arr[3].'/'.$chunk_arr[0].$chunk_arr[1]; } ?>
 All Projects   Project   Print Project 

Change  Click to Change

Refresh Project Name: 
Change Due Date Due Date:  Change Status Status: 
Contact:
Error retrieving contact data.
' . 'Error: '. mysql_error(). '

'); }else{ $row = mysql_fetch_array($listit); $CID = $row['ID']; $first_Name = $row['first_Name']; $Name = $row['Name']; $Phone = $row['Phone']; $email = $row['email']; echo("$first_Name $Name
$Phone
" . "$email"); } ?> 		Edit Products Product:
Events:
Error: ". mysql_error()); }else{ $drows = mysql_num_rows($dates); if($drows < 1){ echo("

No Event Set
Set Event by
clicking on a date
in the Calendar.

"); }else{ while($rowd = mysql_fetch_array($dates)){ $DID = $rowd['ID']; $PID = $rowd['PID']; $CONID = $rowd['CONID']; $title = $rowd['title']; $tid = $rowd['time']; if($tid == '1'){ $time = '6'; $oday = 'AM'; }elseif($tid == '2'){ $time = '7'; $oday = 'AM'; }elseif($tid == '3'){ $time = '8'; $oday = 'AM'; }elseif($tid == '4'){ $time = '9'; $oday = 'AM'; }elseif($tid == '5'){ $time = '10'; $oday = 'AM'; }elseif($tid == '6'){ $time = '11'; $oday = 'AM'; }elseif($tid == '7'){ $time = '12'; $oday = 'AM'; }elseif($tid == '8'){ $time = '1'; $oday = 'PM'; }elseif($tid == '9'){ $time = '2'; $oday = 'PM'; }elseif($tid == '10'){ $time = '3'; $oday = 'PM'; }elseif($tid == '11'){ $time = '4'; $oday = 'PM'; }elseif($tid == '12'){ $time = '5'; $oday = 'PM'; }elseif($tid == '13'){ $time = '6'; $oday = 'PM'; }elseif($tid == '14'){ $time = '7'; $oday = 'PM'; }elseif($tid == '15'){ $time = '8'; $oday = 'PM'; }elseif($tid == '16'){ $time = '9'; $oday = 'PM'; } $min = $rowd['min']; $dtnum = $rowd['dtnum']; $chunk_dtnum = chunk_split($dtnum, 2, ':'); $chunk_arr = explode(":", $chunk_dtnum); $datus = $chunk_arr[2].'/'.$chunk_arr[3].'/'.$chunk_arr[0].$chunk_arr[1]; $datcheck = date(Ymd) + 0; if($dtnum < $datcheck){ echo(""); }else{ echo("

$datus  $time:$min 0 $oday" . "
" . "Click! $title

"); } } } } ?> 		Edit Action List Action List: Error retrieving New Action List.
' . 'Error: '. mysql_error(). '

'); }else{ $numrows = mysql_num_rows($noteit); if($numrows < 1){ echo("

No New Actions

"); }else{ while($rowa = mysql_fetch_array($noteit)){ $PID = $rowa['PID']; $act = $rowa['action']; $adtnum = $rowa['dtnum']; $chunk_adtnum = chunk_split($adtnum, 2, ':'); $chunk_arra = explode(":", $chunk_adtnum); echo("

 $chunk_arra[2]/$chunk_arra[3]/$chunk_arra[0]$chunk_arra[1] - $act

"); } } } $notit = @mysql_query("SELECT PID,action,dtnum FROM task_action WHERE PID='$ID' AND status='Done' ORDER BY dtnum DESC"); if (!$notit) { echo('

Error retrieving Done Action List.
' . 'Error: '. mysql_error(). '

'); }else{ $numrows = mysql_num_rows($noteit); if($numrows < 1){ echo("

$note_date - $action

"); }else{ while($rowa = mysql_fetch_array($notit)){ $PID = $rowa['PID']; $act = $rowa['action']; $adtnum = $rowa['dtnum']; $chunk_adtnum = chunk_split($adtnum, 2, ':'); $chunk_arra = explode(":", $chunk_adtnum); echo("

 $chunk_arra[2]/$chunk_arra[3]/$chunk_arra[0]$chunk_arra[1] - $act

"); } echo("

$note_date - $action

"); } } echo(""); ?>
Add Notes Notes: $note_date - $note

"); $noteit = @mysql_query("SELECT PID,note,dtnum FROM task_notes WHERE PID='$ID' ORDER BY dtnum"); if (!$noteit) { echo('

Error retrieving Project Notes.
' . 'Error: '. mysql_error(). '

'); }else{ $numrows = mysql_num_rows($noteit); if($numrows < 1){ echo("

No More Notes

"); }else{ while($rown = mysql_fetch_array($noteit)){ $PID = $rown['PID']; $noten = $rown['note']; $noten_break = nl2br($noten); $ndtnum = $rown['dtnum']; $chunk_ndtnum = chunk_split($ndtnum, 2, ':'); $chunk_arrn = explode(":", $chunk_ndtnum); echo("

$chunk_arrn[2]/$chunk_arrn[3]/$chunk_arrn[0]$chunk_arrn[1] - $noten_break

"); } } } ?>