if ($focus=="transcript"){
?>
// $transcript="$links $biblios";
selectDatabase("AssetDatabase");
//get biblios collection string
$query="SELECT * FROM linkcollectiontable WHERE id='$links'";
//echo($query);
$result = mysql_query($query);
$row=mysql_fetch_row($result);
global $linkCollectionIDS, $links, $linkID;
$id=$row[0];
$linkCollectionName=$row[1];
$linkCollectionShortDesc=$row[2];
$linkCollectionIDS=$row[3];
// echo("colIDS=$linkCollectionIDS");
//now publications
if ($biblios!="" && $biblios!="none"){
echo("Bibliographies:
");
echo("");
$query="SELECT * FROM pubCollectionTable WHERE id='$biblios'";
//echo($query);
global $link_id;
$result = mysql_query($query, $link_id);
$row=mysql_fetch_row($result);
global $linkCollectionIDS;
$id=$row[0];
$linkCollectionName=$row[1];
$linkCollectionShortDesc=$row[2];
$linkCollectionIDS=$row[3];
$transcript="$transcript $row[1] $row[2] ";
//echo("BIBIDs $linkCollectionIDS
");
$query="SELECT * FROM staffpublicationtable";
$count=1;
$result=mysql_query($query);
while ($row = mysql_fetch_row($result)) {
if ($row[1]!=""){
$sep='/';
$q='"';
if (strPos($linkCollectionIDS, "/$row[0]/")>-1){
$transcript="$transcript $row[7] $row[5] $row[2] $row[3] $row[4] ";
$scanText=" $scanText $row[7] $row[5] $row[2] $row[3] $row[4] ";
//echo("$row[7] ($row[5]). $row[1]. $row[3] ");
if ($row[2]!=""){
// echo("URL:$row[2] ");
}
if($row[4]!=""){
echo("$row[4]
");
}else{
// echo("
");
}
}
?>
$count=$count+1;
//echo (" $row[1] ($row[2]) - $row[3] ");
}
}
echo("
");
}
if ($links!="" && $links!="none"){
selectDatabase("AssetDatabase");
//get biblios collection string
$query="SELECT * FROM linkcollectiontable WHERE id='$links'";
//echo($query);
$result = mysql_query($query);
$row=mysql_fetch_row($result);
global $linkCollectionIDS;
$id=$row[0];
$linkCollectionName=$row[1];
$linkCollectionShortDesc=$row[2];
$linkCollectionIDS=$row[3];
echo("Links:
");
echo("");
// echo($transcript);
$query="Select * FROM linktable ORDER BY linkName";
$count=1;
$result=mysql_query($query);
while ($row = mysql_fetch_row($result)) {
if ($row[1]!=""){
?>
$sep='/';
if (strPos($linkCollectionIDS, "/$row[0]/")>-1){
echo("> $row[1]");
$transcript="$transcript $row[2] $row[3] ";
$scanText="$scanText $row[7] $row[5] $row[2] $row[3] $row[4] ";
if ($row[3]!=""){
echo(" - $row[3]");
}
echo("
");
}
?>
$count=$count+1;
//echo (" $row[1] ($row[2]) - $row[3] ");
}
}
echo("
");
}
}
?>
| |