Deal Of The Day
To Do List : Open Items
Title/Datepriority
//$SelectToDo = "SELECT users.First_Name, users.Last_Name, DATE_FORMAT(Date_Added,'%c/%e/%y') as 'dateAdded',DATE_FORMAT(Due_Date,'%c/%e/%y') as 'dueDate',todo_list.* FROM todo_list, users where (users.ID = '$_SESSION[sessionUserID]') and (users.ID = todo_list.User_ID) and (todo_list.User_ID = '$_SESSION[sessionUserID]' or Assign_To = '$_SESSION[sessionUserID]') and (todo_list.deleted = 0)"; $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 ?>
Grocery Lists : All
List NameDate created
$SelectGrocery = "select distinct Archive_ID, DATE_FORMAT(Create_Date,'%m/%e/%y') as 'lastList',grocery_list_archive.* from privacy,users,grocery_list_archive where (privacy.deleted = 0) AND ((grocery_list_archive.deleted = 0) AND ((privacy.friend_id = users.ID) and (grocery_list_archive.User_ID = users.ID) and (privacy.user_id = '" . $_SESSION["sessionUserID"] . "' or privacy.friend_id = '" . $_SESSION["sessionUserID"] . "') and (privacy.grocery = 'Y'))) order by Create_Date DESC,Archive_ID DESC"; $resultGrocery = mysql_query($SelectGrocery) or die(mysql_error()); if( mysql_num_rows($resultGrocery) <= "0"){ $SelectGrocery = "select DATE_FORMAT(Create_Date,'%m/%e/%y') as 'lastList',grocery_list_archive.* from grocery_list_archive where (grocery_list_archive.deleted = 0) AND (User_ID = '" . $_SESSION["sessionUserID"] . "') order by Create_Date DESC,Archive_ID DESC"; $resultGrocery = mysql_query($SelectGrocery) or die(mysql_error()); } while($MyList=mysql_fetch_array($resultGrocery)){ $arcID = $MyList[Archive_ID] ; ?>- if($MyList[List_Name] > " "){echo $MyList[List_Name];}else{ echo "Untitled List";} ?>
- =$MyList[lastList]?>

Recipe Finder
Search 100’s Of Delicious
Recipes! Add New Recipes
To Your YadaHome
Cookbook!



