Sorry, there is a problem with your username. You must Log in to view this page.
"); exit(); } $dtnum = $_GET['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]; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); ?>Project Notes | All Projects | Project |
Project Name: | |
New Note: | |
mysql_select_db('ecosmar_friendly', $dbcnx);
$note_1 = @mysql_query("SELECT note,dtnum FROM task WHERE ID='$ID' ORDER BY dtnum");
if (!$note_1) {
echo(' Error retrieving Project Note. No original note. "); }else{ echo("$chunk_arrt[2]/$chunk_arrt[3]/$chunk_arrt[0]$chunk_arrt[1] - $note "); } } $noteit = @mysql_query("SELECT PID,note,dtnum FROM task_notes WHERE PID='$ID' ORDER BY dtnum"); if (!$noteit) { echo('Error retrieving Project Notes. No Further Notes "); }else{ while($rown = mysql_fetch_array($noteit)){ $PID = $rown['PID']; $noten = $rown['note']; $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 "); } } } ?> | |