"); } ?> "); $seekCollection=$userow[0]; selectDatabase("CoreDatabase"); $sql2="SELECT * FROM interviewinterviewerlinks WHERE peopleCollection=$seekCollection"; $result2=mysql_query($sql2, $link_id); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name $sql3="SELECT * FROM interviewContent WHERE id=$userow2[1]"; $result3=mysql_query($sql3); while($userow3=mysql_fetch_row($result3)){ $interviewerBlock="$interviewerBlock>".$userow3[1]."
"; } } } //interviewees $intervieweeBlock=""; //get presentations selectDatabase("coredatabase"); $sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'"; $result=mysql_query($sql, $link_id); while($userow=mysql_fetch_row($result)){ //echo("collection $userow[0] :
"); $seekCollection=$userow[0]; selectDatabase("CoreDatabase"); $sql2="SELECT * FROM interviewintervieweelinks WHERE peopleCollection=$seekCollection"; $result2=mysql_query($sql2); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name $sql3="SELECT * FROM interviewContent WHERE id=$userow2[1]"; $result3=mysql_query($sql3); while($userow3=mysql_fetch_row($result3)){ $intervieweeBlock="$intervieweeBlock>".$userow3[1]."
"; } } } //presentations - particiapnt $participantBlock=""; //get presentations selectDatabase("coredatabase"); $sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'"; $result=mysql_query($sql, $link_id); while($userow=mysql_fetch_row($result)){ //echo("collection $userow[0] :
"); $seekCollection=$userow[0]; selectDatabase("coredatabase"); $sql2="SELECT * FROM presentationparticipantlinks WHERE peopleCollection=$seekCollection"; $result2=mysql_query($sql2, $link_id); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name $sql3="SELECT * FROM presentationtable WHERE id=$userow2[1]"; $result3=mysql_query($sql3, $link_id); while($userow3=mysql_fetch_row($result3)){ $participantBlock="$participantBlock>".$userow3[2]."
"; } } } //presentations - attendee $attendeeBlock=""; //get presentations selectDatabase("coredatabase"); $sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'"; $result=mysql_query($sql, $link_id); while($userow=mysql_fetch_row($result)){ //echo("collection $userow[0] :
"); $seekCollection=$userow[0]; selectDatabase("coredatabase"); $sql2="SELECT * FROM presentationattendeeLinks WHERE peopleCollection=$seekCollection"; $result2=mysql_query($sql2, $link_id); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name $sql3="SELECT * FROM presentationtable WHERE id=$userow2[1]"; $result3=mysql_query($sql3, $link_id); while($userow3=mysql_fetch_row($result3)){ $attendeeBlock="$attendeeBlock>".$userow3[2]."
"; } } } //exhibitions - curator $exhibitionBlock=""; //get presentations selectDatabase("coredatabase"); $sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'"; // echo($sql); $result=mysql_query($sql, $link_id); while($userow=mysql_fetch_row($result)){ //echo("collection $userow[0] :
"); $seekCollection=$userow[0]; selectDatabase("coredatabase"); $sql2="SELECT * FROM exhibitioncuratorlinks WHERE curator=$seekCollection"; // echo($sql2); $result2=mysql_query($sql2); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name $sql3="SELECT * FROM exhibitiontable WHERE id=$userow2[1]"; // echo($sql3); $result3=mysql_query($sql3, $link_id); while($userow3=mysql_fetch_row($result3)){ $exhibitionBlock="$exhibitionBlock>".$userow3[2]."
"; } } } //crumb reports - author $reportsBlock=""; //get presentations selectDatabase("coredatabase"); $sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'"; //echo($sql); $result=mysql_query($sql, $link_id); while($userow=mysql_fetch_row($result)){ //echo("collection $userow[0] :
"); $seekCollection=$userow[0]; selectDatabase("coredatabase"); $sql2="SELECT * FROM pdfparticipantLinks WHERE peopleCollection=$seekCollection"; // echo($sql2); $result2=mysql_query($sql2, $link_id); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name selectDatabase("assetdatabase"); $sql3="SELECT * FROM reportdatabase WHERE id=$userow2[1]"; // echo($sql3); $result3=mysql_query($sql3, $link_id); while($userow3=mysql_fetch_row($result3)){ $sql4="SELECT COUNT(*) FROM reportcollectiontable WHERE reportCollectionName='_CRUMB_REPORTS' AND reportCollectionIDs LIKE '%/$userow2[1]/%'"; // echo($sql4); $result4=mysql_query($sql4, $link_id); $row4=mysql_fetch_row($result4); // echo($row4[3]); if ($row4[0]>0){ $reportsBlock="$reportsBlock> $userow3[1]       (download report)
"; } } } } //cullen guides - author $cullenGuidesBlock=""; //get presentations selectDatabase("coredatabase"); $sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'"; //echo($sql); $result=mysql_query($sql, $link_id); while($userow=mysql_fetch_row($result)){ //echo("collection $userow[0] :
"); $seekCollection=$userow[0]; selectDatabase("coredatabase"); $sql2="SELECT * FROM pdfparticipantlinks WHERE peopleCollection=$seekCollection"; // echo($sql2); $result2=mysql_query($sql2, $link_id); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name selectDatabase("assetdatabase"); $sql3="SELECT * FROM reportdatabase WHERE id=$userow2[1]"; // echo($sql3); $result3=mysql_query($sql3, $link_id); while($userow3=mysql_fetch_row($result3)){ $sql4="SELECT COUNT(*) FROM reportcollectiontable WHERE reportCollectionName='_CULLEN_GUIDES' AND reportCollectionIDs LIKE '%/$userow2[1]/%'"; // echo($sql4); $result4=mysql_query($sql4); $row4=mysql_fetch_row($result4); // echo($row4[3]); if ($row4[0]>0){ $cullenGuidesBlock="$cullenGuidesBlock> $userow3[1]       (download report)
"; } } } } //discussion files author $discussionArchiveBlock=""; //get presentations selectDatabase("coredatabase"); $sql="SELECT * FROM peoplecollectiontable WHERE peopleCollectionIDs LIKE '%/$personID/%'"; //echo($sql); $result=mysql_query($sql, $link_id); while($userow=mysql_fetch_row($result)){ //echo("collection $userow[0] :
"); $seekCollection=$userow[0]; selectDatabase("CoreDatabase"); $sql2="SELECT * FROM pdfparticipantlinks WHERE peopleCollection=$seekCollection"; // echo($sql2); $result2=mysql_query($sql2, $link_id); while($userow2=mysql_fetch_row($result2)){ // echo("interview - $userow2[1]"); //now get the interview name selectDatabase("assetdatabase"); $sql3="SELECT * FROM reportdatabase WHERE id=$userow2[1]"; // echo($sql3); $result3=mysql_query($sql3, $link_id); while($userow3=mysql_fetch_row($result3)){ $sql4="SELECT COUNT(*) FROM reportcollectiontable WHERE reportCollectionName='_DISCUSSION_ARCHIVE_FILES' AND reportCollectionIDs LIKE '%/$userow2[1]/%'"; // echo($sql4); $result4=mysql_query($sql4); $row4=mysql_fetch_row($result4); // echo($row4[3]); if ($row4[0]>0){ $discussionArchiveBlock="$dscussionArchiveBlock> $userow3[1]       (download report)
"; } } } } if ($interviewerBlock<>""){ echo("Interviews (as interviewer):
$interviewerBlock
"); } if ($intervieweeBlock<>""){ echo("Interviews (as interviewee):
$intervieweeBlock
"); } if ($participantBlock<>""){ echo("Presentations (as participant):
$participantBlock
"); } if ($attendeeBlock<>""){ echo("Presentations (as attendee):
$attendeeBlock
"); } if ($exhibitionBlock<>""){ echo("Exhibitions (as curator):
$exhibitionBlock
"); } if ($reportsBlock<>""){ echo("Crumb Reports (as author):
$reportsBlock
"); } if ($cullenGuidesBlock<>""){ echo("Cullen Guides (as author):
$cullenGuidesBlock
"); } if ($discussionArchiveBlock<>""){ echo("Discussion Archives (as participant):
$discussionArchiveBlock
"); } ?>

---