require ("../../includes/header.ssi");
?>
include ('dbconnect.php');
echo "Dickson Preston Collection
";
echo 'Title Display
';
$sql = "select title,barcode,location,publication,pubdate,pubvol,issue,pubstart,pubend,place from title t,publication p, place pl where pid=p.id and plid=pl.id and t.id = '$id'";
$result = mysql_query($sql) or die (mysql_error());
list($title,$barcode,$location,$publication,$pubdate,$pubvol,$issue,$pubstart,$pubend,$place) = mysql_fetch_row($result);
echo "
Title |
$title |
Barcode |
$barcode |
Location |
$location |
";
if ($pubdate != "") {
echo "
Publication Date |
$pubdate |
";
}
if ($publication != "None") {
echo "
Publication |
$publication |
";
}
if ($place != "None") {
echo "
Publication Place |
$place |
";
}
if ($pubvol != "") {
echo "
Volume |
$pubvol |
";
}
if ($issue != "") {
echo "
Issue |
$issue |
";
}
if ($pubstart != "") {
echo "
Start Page |
$pubstart |
";
}
if ($pubend != "") {
echo "
End Page |
$pubend |
";
}
echo "
";
?>