";
//get stuff from the table
$result1 = pg_Exec ($conn, "select manifestation_id from subject_manifestation where (subject_id='7694')");
if (!$result1) {
echo "
No items matching that category can be found
";
echo "
";
exit;
}
$num1 = pg_numrows($result1);
$i=0;
while ($i<$num1) {
$r1 = pg_fetch_row($result1, $i);
$result2 = pg_Exec($conn, "select u.urn_url, m.manifestation_id, m.form, m.pub_year, m.content_note, u.manifestation_id from manifestation m, urn_url u where (m.manifestation_id='$r1[0]') and (m.manifestation_id=u.manifestation_id) and (manifestation.form != 'book') and (manifestation.form != 'journal article') and (manifestation.form != 'report') and (manifestation.form != 'pamphlet') and (manifestation.form != 'pamphlet/bulletin') and (manifestation.form != 'newspaper article') and (manifestation.form != 'transcript')");
if (!$result2) {
echo "