My Network
$totalToShow=4;
//get network
$SelectStr = "select privacy.*,users.Photo,users.ID,users.First_Name, users.Last_Name, users.BIO, users.Gender, DATE_FORMAT(users.Birth_Date, '%b, %Y') as dob, users.City, users.State_Reside from privacy,users where (privacy.deleted = 0) AND ((privacy.user_id = users.ID) and (privacy.friend_id = '" . $_SESSION["sessionUserID"] . "')) order by Last_Name, First_Name limit 4";
$result = mysql_query($SelectStr) or die(mysql_error());
while($myrow=MySQL_fetch_array($result)){
$totalToShow--;
?>
-
= ucfirst($myrow["First_Name"]) ?> = ucfirst($myrow["Last_Name"]) ?>
- Joined
} ?>
//get network
if($totalToShow > 0){
$SelectStr = "select* from invitations where USER_ID = '" . $_SESSION["sessionUserID"] . "' and Fname > '' and Accepted <> 'Y' order by Fname limit $totalToShow ";
$result = mysql_query($SelectStr) or die(mysql_error());
while($myrow=MySQL_fetch_array($result)){
?>
-
= ucwords($myrow["Fname"]) ?>
- Invited
}
}?>
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"){ echo $ToDo['dueDate'] . "
"; }else{echo " ";} ?>=$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] ;
?>
}
?>
Calendar
= date('F')?> = date('Y')?>
Recipe Finder
Search 100’s Of Delicious Recipes! Add New Recipes To Your YadaHome Cookbook!
Browse Recipes
|