Grand Father Sample FamilyTotal family members: 17 |
// get the MASTER_IDs of members who have BRANCH_TABLENAME is not empty $sql_f = "SELECT * FROM $tableName WHERE BRANCH_TABLENAME !='' "; $result_f = mysqli_query($cxn,$sql_f) or die("Could not execute query for BRANCH_TABLENAME"); // put into $arrayf[] all MASTER_ID w BRANCH_TABLENAME while($rec_f = mysqli_fetch_assoc($result_f)) { $varmasteridf=$rec_f["MASTER_ID"]; $arrayf[]=$varmasteridf;} //echo "varmasteridf:$varmasteridf "; $Branch='No'; ?> $BackgroundIcon = ''; $UnderlineNotUnderline='underline'; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; $UnderlineNotUnderline='underline'; ?> $BackgroundIcon = ''; $UnderlineNotUnderline='underline'; ?> $BackgroundIcon = ''; $UnderlineNotUnderline='underline'; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; $UnderlineNotUnderline='underline'; ?> $BackgroundIcon = ''; ?> $BackgroundIcon = ''; ?> |
if ($UserMaster_ID != 'New')
{
// MESSAGE
// Get Subscriber Master_ID
//***************************************************************************************
$query = "SELECT * FROM Member WHERE familyTree = '$tableName'
AND subscriber !='0000-00-00'";
$result = mysqli_query($cxn,$query); //or die("Couldn't execute query Member");
$numrowsLevel = mysqli_num_rows($result);
$rec = mysqli_fetch_assoc($result);
$SubscriberMaster_ID = $rec["MASTER_ID"];
//echo "$SubscriberMaster_ID
"; //echo "tablename:$tableName
"; // get subsciber message $query = "SELECT * FROM $tableName WHERE MASTER_ID = $SubscriberMaster_ID"; $result = mysqli_query($cxn,$query) or die("Couldn't execute query"); $numrows = mysqli_num_rows($result); $rec = mysqli_fetch_assoc($result); //echo "numrows:$numrows
"; $text = $rec["MESSAGE"];?>
if ($text != '') {?> } }?>
"; //echo "tablename:$tableName
"; // get subsciber message $query = "SELECT * FROM $tableName WHERE MASTER_ID = $SubscriberMaster_ID"; $result = mysqli_query($cxn,$query) or die("Couldn't execute query"); $numrows = mysqli_num_rows($result); $rec = mysqli_fetch_assoc($result); //echo "numrows:$numrows
"; $text = $rec["MESSAGE"];?>
if ($text != '') {?> } }?>
include ('blog-redesign1.php');?>
// Get data //echo "treeviewtablename:$treeviewtablename
"; $querytreeview = "SELECT * FROM $treeviewtablename ORDER BY NAME ASC"; $resulttreeview = mysqli_query($cxn,$querytreeview) or die("Couldn't execute query level2."); ?>
To Search For A Family Member - Click on name | ||||
echo $count; ?> | // Display number and PHOTO ?> |
// Display text link of NAME ?> | echo "$treeviewPHOTOALBUMNO";?> | echo "$treeviewVIDEONO";?> |
"; //echo "searchthistreeviewLevelNo:$searchthistreeviewLevelNo
"; if ($searchthisMaster_ID !='') { //echo "In If $searchthisMaster_ID is not Blank
";?> }?>