\n"; } else { $sql = "select * from crea_rec where crea_id = '$id'"; } $res = mysql_query($sql); $rows = mysql_num_rows($res); print "$rows record(s)

\n"; while ($row=mysql_fetch_array($res)) { $record_id = $row[record_id]; $sql = "select * from record where record_id = '$record_id'"; $res2 = mysql_query($sql); while($row2=mysql_fetch_array($res2)) { print "

\n"; print "Title: $row2[title]
\n"; print "Call Number: $row2[callnumber]
\n"; print "\n"; printCS ("crea_rec", $record_id, "creator", "creator_id", "crea_id", "Interviewee", "creator"); printCS ("contrib_rec", $record_id, "contrib", "contrib_id", "contrib_id", "Interviewer", "contrib"); print "Repository: Charles Babbage Institute, University of Minnesota, Minneapolis
\n"; //print "Genre/form: $row2[genre]
\n"; print "Description: $row2[descrip]

\n"; print "Abstract: $row2[abstract]

\n"; printSubject ($record_id); print "

\n"; //print "Date: $row2[datum]
\n"; //print "Place: $row2[place]
\n"; print "Citation: $row2[citation]

\n"; if ($row2[note]) { print "Note: $row2[note]

\n"; } print "Copyright: $row2[copyright]

\n"; if ($row2[link]) { print "Transcript: Link to transcript
\n"; } else { print "Transcript: Transcript not available electronically. Please contact CBI.
\n"; } print "