" " && $_REQUEST['fid'] > " "){ $SelectStr2 = "SELECT * FROM contacts where ID = '" . $_REQUEST["cid"] . "' and User_ID = '" . $_REQUEST['fid'] . "'"; $result2 = mysql_query($SelectStr2) or die(mysql_error()); if($myrow2=MySQL_fetch_array($result2)){ $SQL = "INSERT INTO contacts ( User_ID, First_Name, Last_Name, Email, Phone, Mobile, Work, Address_1, Address_2, City, State_Residence, Zip) VALUES ( '" . $_SESSION["sessionUserID"] . "' , '" . $myrow2["First_Name"] . "' , '" . $myrow2["Last_Name"] . "' , '" . $myrow2["Email"] . "' , '" . $myrow2["Phone"] . "' , '" . $myrow2["Mobile"] . "' , '" . $myrow2["Work"] . "' , '" . $myrow2["Address_1"] . "' , '" . $myrow2["Address_2"] . "' , '" . $myrow2["City"] . "' , '" . $myrow2["State_Residence"] . "' , '" . $myrow2["Zip"] . "')"; $result = mysql_query($SQL) or die(mysql_error()); $added = "Y" ; } } if($_REQUEST['fid'] > " "){ $_SESSION["sessionFriendUserID"] = $_REQUEST['fid'] ; $fid = $_SESSION["sessionFriendUserID"]; } else { $fid = $_SESSION["sessionFriendUserID"]; } if($_REQUEST['fid'] > " " ){ $userID = $_REQUEST['fid']; //MAKE SURE THIS USER IS SUPPOSED TO SEE THIS $SelectStr = "select * from privacy where (privacy.deleted = 0) AND ((privacy.user_id = '" . $_REQUEST['fid'] . "') and (privacy.friend_id = '" . $_SESSION["sessionUserID"] . "') and (contacts = 'Y') )"; $result = mysql_query($SelectStr) or die(mysql_error()); if($myrow=MySQL_fetch_array($result)){ $friendok = 'y'; $friendPhoto = $myrow["photo"] ; $friendBlog = $myrow["blog"] ; $friendContact = $myrow["contacts"] ; $friendCook = $myrow["cookbook"] ; $friendProfile = $myrow["show_profile_page"] ; $SelectFr = "SELECT Photo,DATE_FORMAT(Last_Logon, '%M %d, %Y') as lastLog,First_Name,Last_Name,ID FROM users where ID = '" . $_REQUEST['fid'] . "' "; $resultFr = MySQL($dbName,$SelectFr) or die(mysql_error()); if($myrowFr=MySQL_fetch_array($resultFr)){ $First_Name = ucfirst($myrowFr["First_Name"]); $Last_Name = ucfirst($myrowFr["Last_Name"]); $lastLog = $myrowFr["lastLog"] ; } } else { $SelectFr = "SELECT Photo,DATE_FORMAT(Last_Logon, '%M %d, %Y') as lastLog,First_Name,Last_Name,ID FROM users where ID = '" . $_SESSION["sessionUserID"] . "' "; $resultFr = MySQL($dbName,$SelectFr) or die(mysql_error()); if($myrowFr=MySQL_fetch_array($resultFr)){ $First_Name = ucfirst($myrowFr["First_Name"]); $Last_Name = ucfirst($myrowFr["Last_Name"]); $lastLog = $myrowFr["lastLog"] ; } } } else { $SelectFr = "SELECT Photo,DATE_FORMAT(Last_Logon, '%M %d, %Y') as lastLog,First_Name,Last_Name,ID FROM users where ID = '" . $_SESSION["sessionUserID"] . "' "; $resultFr = MySQL($dbName,$SelectFr) or die(mysql_error()); if($myrowFr=MySQL_fetch_array($resultFr)){ $First_Name = ucfirst($myrowFr["First_Name"]); $Last_Name = ucfirst($myrowFr["Last_Name"]); $lastLog = $myrowFr["lastLog"] ; $myProfile = "y"; } } ?>

" ") { ?> " alt="profile" class="profileImage" /> 's contacts Back family contacts friend contacts emergency contacts work contacts all contacts    contacts: " "){ ?>the letter all Contact hes been added " "){ $SelectStr = "SELECT * FROM contacts where User_ID ='$userID' and Last_Name like '" . $_REQUEST["l"] . "%' ORDER BY Last_Name, First_Name"; } if( ($_REQUEST["type"] > " ") && ($_REQUEST["type"] <> "emergency") && ($_REQUEST["type"] <> "all") ){ $SelectStr = "SELECT * FROM contacts where User_ID ='$userID' and Type = '" . $_REQUEST["type"] . "' ORDER BY Last_Name, First_Name"; } if( ($_REQUEST["type"] == "emergency") ){ $SelectStr = "SELECT * FROM contacts where User_ID ='$userID' and Emergency = 'Y' ORDER BY Last_Name, First_Name"; } if( $_REQUEST["contactSearch"] > " "){ $SelectStr = "SELECT * FROM contacts where User_ID ='$fid' and (Last_Name like '" . $_REQUEST["contactSearch"] . "%' ) or (First_Name like '" . $_REQUEST["contactSearch"] . "%' ) ORDER BY Last_Name, First_Name"; } $result = mysql_query($SelectStr) or die(mysql_error()); $num_rows = mysql_num_rows($result); while($myrow=MySQL_fetch_array($result)){ if($j == "4"){ $j = 1 ;} $contact_id[$j] = $myrow["ID"]; if($td == "4"){ $td = 1 ;} ?> , " " || $myrow["Address_2"] > " "){ ?>  " " || $myrow["State"] > " " || $myrow["Zip"] > " "){ ?> " "){ ?>, " "){ ?>m " "){ ?>h " "){ ?>w " "){ ?>e ">       Add to My Contacts "1"){?>Add to My Contacts "2"){?>Add to My Contacts To edit your contacts, you must goto your fridge. Remove as Friends