"); ?>
"); if ($counter==5){ echo(""); $counter=0; } echo("
".chr($lop).""); //get the people selectDatabase("coredatabase"); $sql="select * from peopletable WHERE surName LIKE '".chr($lop)."%' AND type LIKE '%$t%'"; // echo($sql); $resultNams= mysql_query($sql,$link_id); while ($rowNams = mysql_fetch_row($resultNams)) { echo("
$rowNams[1] $rowNams[3] $rowNams[2]
"); } echo("
"); } ?>



"); if ($counter==5){ echo(""); $counter=0; } echo("
".chr($lop).""); //get the people selectDatabase("coredatabase"); $sql="select * from lexicontable WHERE lexterm LIKE '".strtolower(chr($lop))."%'"; // echo($sql); $resultNams= mysql_query($sql,$link_id); while ($rowNams = mysql_fetch_row($resultNams)) { echo("
$rowNams[1]
"); } echo("
"); } ?>
0){ if ($haveDone==1){echo(", ");} if ($countArray[$lop]==1){ $useRef=$refArray2[$lop]; }else{ $useRef=$refArray[$lop]; } if ($haveDone==0){ $focus=$typeArray[$lop]; $haveDone=1; } echo($countArray[$lop]." ".$useRef); } } } ?> ", " ",$m); $m2=str_replace(" > ", " ",$m); $m=$m2; $startTerm=strpos($m,$searchTerm); $origPlace=$startTerm; $startTerm=$startTerm-20; $startTerm2=$startTerm; if($startTerm<1){ $startTerm2=1; } $startTerm2=strpos($m," ",$startTerm2); $endTerm=strpos($m,". ",$origPlace); if ($endTerm<$startTerm+10){ $endTerm=$endTerm+10; } //echo(" $searchTerm $startTerm $endTerm "); $context=substr($m,$startTerm2, $endTerm-$startTerm2); $context2=$context; //$startTerm2=strpos($context2," ",$startTerm2); //$endTerm=strpos($context2,". ",$origPlace); if (strpos($context2, "

")>0){ $startBody=strpos($context2, "

")+3; //echo("startbody= $startBody"); $context2=substr($context2,$startBody); } $lowerSearch=strtolower($searchTerm); $lowerSearchNOSP=strtolower($searchTermNOSP); $context3=str_replace("$searchTerm", "$searchTerm",$context2); $context4=str_replace("$lowerSearch", "$lowerSearch",$context3); $context5=str_replace("$searchTermNOSP,", "$searchTermNOSP,",$context4); $context6=str_replace("$lowerSearchNOSP,", "$lowerSearchNOSP,",$context5); $context7=str_replace("$searchTermNOSP.", "$searchTermNOSP.",$context6); $context8=str_replace("$lowerSearchNOSP.", "$lowerSearchNOSP.",$context7); $context4=$context8; $context5=str_replace("
", " ",$context4); if (strLen($context5)>220){ $context5=subStr($context5,1,220); } echo("...".strip_tags($context5)."...




"); } ?> >Summary"; $countArray = array(); $cats=array(); $discSearchTerm=urlencode($searchTerm); $refArray = array("interviews","presentations","images","sound","video","bio","downloads","links","discussion"); $typedArray = array("Interviews","Presentations","Images","Sound","Video","Profile","Downloads","Links", "Discussion"); $dbArray=array("CoreDatabase","CoreDatabase","AssetDatabase","AssetDatabase","AssetDatabase","CoreDatabase","AssetDatabase","AssetDatabase","jiscDiscussionDatabase"); $queryArray=array("SELECT COUNT(*) FROM interviewContent WHERE title LIKE '%$searchTerm%' OR keywords LIKE '%$searchTerm%' OR transcript LIKE '%$searchTerm%' OR introText LIKE '%$searchTerm%'","SELECT COUNT(*) FROM presentationtable WHERE title LIKE '%$searchTerm%' OR keywords LIKE '%$searchTerm%' OR fullT LIKE '%$searchTerm%' OR fragments LIKE '%$searchTerm%' OR keywords LIKE '%searchTerm%'","SELECT COUNT(*) FROM imageDatabase WHERE imageTitle LIKE '%$searchTerm%' OR imageAbstract LIKE '%$searchTerm%' OR imageCredit LIKE '%$searchTerm%'","SELECT COUNT(*) FROM sounddatabase WHERE soundTitle LIKE '%$searchTerm%' OR soundAbstract LIKE '%$searchTerm%' OR soundCredit LIKE '%$searchTerm%'","SELECT COUNT(*) FROM videodatabase WHERE videoTitle LIKE '%$searchTerm%' OR videoAbstract LIKE '%$searchTerm%' OR videoCredit LIKE '%$searchTerm%'","SELECT COUNT(*) FROM peopletable WHERE name LIKE '%$searchTerm%' OR surName LIKE '%$searchTerm%' OR shortBio LIKE '%$searchTerm%' OR longBio LIKE '%$searchTerm%'","SELECT COUNT(*) FROM reportdatabase WHERE reportTitle LIKE '%$searchTerm%' OR reportAbstract LIKE '%$searchTerm%' OR reportCredit LIKE '%$searchTerm%' OR fP LIKE '%$searchTerm%' OR misc LIKE '%$searchTerm%' OR fT LIKE '%$searchTerm%'","SELECT COUNT(*) FROM linktable WHERE linkName LIKE '%$searchTerm%' OR linkShortDesc LIKE '%$searchTerm%' OR linkLongDesc LIKE '%$searchTerm%'","SELECT COUNT(*) FROM jiscdiscussiontable WHERE content LIKE '%$searchTerm%' OR content LIKE '%$discSearchTerm%'"); $queryArrayContent=array("SELECT * FROM interviewContent WHERE title LIKE '%$searchTerm%' OR keywords LIKE '%$searchTerm%' OR transcript LIKE '%$searchTerm%' OR introText LIKE '%$searchTerm%'","SELECT * FROM presentationtable WHERE title LIKE '%$searchTerm%' OR keywords LIKE '%$searchTerm%' OR fullT LIKE '%$searchTerm%' OR fragments LIKE '%$searchTerm%' OR keywords LIKE '%searchTerm%'","SELECT * FROM imageDatabase WHERE imageTitle LIKE '%$searchTerm%' OR imageAbstract LIKE '%$searchTerm%' OR imageCredit LIKE '%$searchTerm%'","SELECT * FROM sounddatabase WHERE soundTitle LIKE '%$searchTerm%' OR soundAbstract LIKE '%$searchTerm%' OR soundCredit LIKE '%$searchTerm%'","SELECT * FROM videodatabase WHERE videoTitle LIKE '%$searchTerm%' OR videoAbstract LIKE '%$searchTerm%' OR videoCredit LIKE '%$searchTerm%'","SELECT * FROM peopletable WHERE name LIKE '%$searchTerm%' OR surName LIKE '%$searchTerm%' OR shortBio LIKE '%$searchTerm%' OR longBio LIKE '%$searchTerm%'","SELECT * FROM reportdatabase WHERE reportTitle LIKE '%$searchTerm%' OR reportAbstract LIKE '%$searchTerm%' OR reportCredit LIKE '%$searchTerm%' OR fP LIKE '%$searchTerm%' OR misc LIKE '%$searchTerm%' OR fT LIKE '%$searchTerm%'","SELECT * FROM linktable WHERE linkName LIKE '%$searchTerm%' OR linkShortDesc LIKE '%$searchTerm%' OR linkLongDesc LIKE '%$searchTerm%'","SELECT * FROM jiscdiscussiontable WHERE content LIKE '%$searchTerm%' OR content LIKE '%$discSearchTerm%'"); ?> $countVal"); //array_push($countArray, $countVal); ?> $typedArray[$lop-1]>".$typedArray[$lop-1]." "; if ($tabcounter==2){ $tabcounter=0; $tabBlock="$tabBlock"; } ?>