
to do | cal
To Do List : Open Items
Title/Datepriority
$SelectToDo = "SELECT DATE_FORMAT(Date_Added,'%c/%e/%y') as 'dateAdded',DATE_FORMAT(Due_Date,'%c/%e/%y') as 'dueDate',todo_list.* FROM todo_list where (todo_list.User_ID = '$_SESSION[sessionUserID]' or Assign_To = '$_SESSION[sessionUserID]') and (todo_list.deleted = 0) "; $SelectToDo .= $sqlSearch ; $SelectToDo .= " GROUP BY todo_list.ID ORDER BY Due_Date limit 10" ; $SelectToDo .= $sqlSort ; $resultToDo = mysql_query($SelectToDo) or die(mysql_error()); while($ToDo=mysql_fetch_array($resultToDo)){ if($_SESSION['sessionUserID'] == $ToDo['User_ID']){ $posterName = $_SESSION['sessionFname'] . " " . substr( $_SESSION['sessionLname'] , 0, 1) . "."; }else{ $posterName = ""; $SelectName = "SELECT First_Name, Last_Name from users where ID = '" . $ToDo['User_ID'] . "'"; $resultName = mysql_query($SelectName) or die(mysql_error()); if($NameRow=mysql_fetch_array($resultName)){ $posterName = $NameRow[First_Name] . " " . substr( $NameRow[Last_Name], 0, 1) . "."; } } //$posterName = $ToDo[First_Name] . " " . substr( $ToDo[Last_Name], 0, 1) . "."; switch ($ToDo[Priority_Ind]) { case "1": $PriorityInd = " class='red_text' " ; $PriorityText = "URGENT" ; break; case "2": $PriorityInd = " class='red_text' " ; $PriorityText = "HIGH" ; break; case "3": $PriorityInd = " class='gran_text' " ; $PriorityText = "NORMAL" ; break; default: $PriorityInd = " class='gran_text' " ; $PriorityText = "NORMAL" ; break; } ?>-
if($ToDo['dueDate'] <> "0/0/00"){ ?>>= $ToDo['dueDate'] ?> } ?>
=$ToDo[Title]?>
Posted by = $posterName ?> - >
= $PriorityText ?>
