"); if($_GET[search]<>$nothing){ ?> Search results for term '' found:

[]

$nothing){ ?>

Results for Category ''

","

",$summary); echo("$summary2"); } ?>

"); ?>

"); 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, "

"); } ?> >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"; } ?> "; // //END OF WORK OUT SEARCH TABS } ?> collection $row2[0]
"); $sql3="SELECT Seminar from seminarpresentationlinks WHERE presentationCollection=$row2[0]"; $result3=mysql_query($sql3,$link_id); while ($row3 = mysql_fetch_row($result3)) { // echo("seminar:$row3[0]"); $sID=$row3[0]; } } echo("Presentation: $row[2]

"); showSearchContext($row[7]." ".$row[6]." ".$row[1]); } } //ends presentations ?> Interview: $row[1]

"); showSearchContext($row[5]." ".$row[4]." ".$row[1]); } } ?> Profile: $row[1] $row[3] $row[2]

"); showSearchContext($row[7]." ".$row[6]." "); } } ?> Link: $row[1]

$row[3] $row[4]
[$row[2]]

"); //showSearchContext($row[1]." ".$row[2]." ".$row[3]." ".$row[4]); } } ?> Download: $row[1]

$row[2]

"); //showSearchContext($row[1]." ".$row[2]." ".$row[4]); } } ?> Sound: $row[1]

"); } } ?> Video: $row[1] - $row[2]

"); } } ?> ", " ",$m); $m=$m2; //echo($m); //get list extract $startTerm=strpos($m,$searchTerm); $origPlace=$startTerm; $startTerm=$startTerm-20; $startTerm2=$startTerm; if($startTerm<1){ $startTerm2=1; } $startTerm2=strpos($m," ",$startTerm2); $endTerm=strpos($m,". ",$origPlace); //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; $fromSubs=strpos ($m,''); $fromSube=strpos ($m,'
',$fromSubs+1); $fromSubBlock=substr($m,$fromSubs, $fromSube-$fromSubs); $fromSubBlock=str_replace(''); $subend=strpos($m,'
',($substart+1)); $subject=substr($m,$substart, $subend-$substart); $subs2=strpos($subject,'')+28; $subj2=substr($subject,$subs2); $subj2=str_replace('">','', $subj2); //echo($subj2); $subs3=strpos($subj2,'">')+2; //echo($subs3); $subj3=substr($subj2,$subs3); //echo(""); $fullBlock="
List Posting: $subj3
$fromSubBlock

".chr(13); $fullBlock2=str_replace('', "",$fullBlock); $fullBlock3=str_replace('', "", $fullBlock2); $summary="$summary $fullBlock3"; $context5=str_replace("
", " ",$context4); if (strLen($context5)>220){ $context5=subStr($context5,1,220); } $summary="$summary...$context5...

"; //$summary="$summary Discussion: $row10[1] $row10[3] $row10[2]

"; //$summary="$summary "); //echo($result); global $projID, $haveFound, $userow, $link_id; $result=mysql_query($sql,$link_id); while($userow=mysql_fetch_row($result)){ $caption=$userow[1]; //now get the project selectDatabase("assetdatabase"); $SQL2="SELECT * FROM imagecollectiontable WHERE imageCollectionIDs LIKE '%/$userow[0]/%'"; //echo($SQL2); $result2=mysql_query($SQL2, $link_id); //echo("PROJID=$projID"); //echo("hello"); $thumbWidth=$userow[6]; $thumbHeight=$userow[7]; //echo("a- $thumbWidth $thumbHeight"); if ($thumbWidth>0){ $showThumbHeight=$thumbHeight/($thumbHeight/100); $showThumbWidth=$thumbWidth/($thumbHeight/100); //echo("b"); $largeWidth=$userow[8]; $largeHeight=$userow[9]; //echo("a - $thumbWidth $thumbHeight"); //$showLargeHeight=$largeHeight/($largeHeight/100); //$showLargeWidth=$largeWidth/($largeHeight/100); $imCount=$imCount+1; $imsrc=$userow[16]; if($imsrc==""){ $imsrc=$userow[4]; } ?>

2){ $imCount=0; echo("

"); } $imString=subStr($imString, $nextSlash, strLen($imString)); }//closed here both global $work, $artist; //echo("

$artist | $work

"); ?> "); $imCount=1; $result="SELECT * FROM imageDatabase WHERE imageTitle LIKE '%$searchTerm%' OR imageAbstract LIKE '%$searchTerm%' OR imageCredit LIKE '%$searchTerm%'"; //echo($result); $sql=mysql_query($result,$link_id); while($userow=mysql_fetch_row($sql)){ $thumbWidth=120; $thumbHeight=90; //echo("$thumbWidth $thumbHeight"); //$showThumbHeight=$thumbHeight/($thumbHeight/90); //$showThumbWidth=$thumbWidth/($thumbHeight/90); //$largeWidth=$userow[8]; //$largeHeight=$userow[9]; //echo("$thumbWidth $thumbHeight"); //$showLargeHeight=$largeHeight/($largeHeight/90); //$showLargeWidth=$largeWidth/($largeHeight/90); $title=$userow[10]; $imCount=$imCount+1; $imsrc=$userow[16]; if($imsrc==""){ $imsrc=$userow[4]; } //echo("seeval is $seekVal
"); ?>

3){ $imCount=1; echo(""); } $imString=subStr($imString, $nextSlash, strLen($imString)); } echo(""); //echo("

"); //end now show the images } ?>