'; echo '.'; echo '

'; echo '
'; echo ''; ?>
'; ?> "; } if ($cat_num != null) { $sql = "select locality_number from t_catalogue where catalogue_number = '$cat_num';"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); $loc_num = $data[0]; } pg_close($dbh); $sql = "select collection_number from t_collection where catalogue_number = '$cat_num';"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); $coll_num = $data[0]; } pg_close($dbh); $sql = "select file_name from t_image where catalogue_number = '$cat_num';"; echo ''; } $sql = "select type, type_status, genus, species, higher_taxon, comments, ident_last_name, ident_first_name from t_identification where catalogue_number = '$cat_num';"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); echo ""; echo ""; echo ""; echo ""; } pg_close($dbh); $sql = "select component_number, description, remarks, status_fate, duplicate from t_component where catalogue_number = '$cat_num';"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); echo ""; echo ""; echo ""; } pg_close($dbh); $sql = "select other_number, type_of_number, reference_inst, expedition_name from t_numbers where catalogue_number = '$cat_num';"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); echo ""; echo ""; echo ""; } pg_close($dbh); $sql = "select expedition_name, coll_last_name, coll_first_name, date_collected from t_collector where catalogue_number = '$cat_num';"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); echo ""; echo ""; echo ""; } pg_close($dbh); $sql = "select locality_name, locality_description, erathem_era, system_period, series_epoch, stage_age, lma, group_x, formation, memeber, bed, continent, country, state, county, stratigraphic_notes, year, expedition_name, collection, collector, lower_unit, upper_unit, distance_below, distance_above, old_locality_number from t_locality where locality_number = $loc_num;"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo " $data[18]"; } pg_close($dbh); $sql = "select t_author.last_name, t_author.first_name, t_publication.year, t_publication.title, t_publication.editors, t_publication.journal, t_publication.collation, t_publication.key_words, t_publication.abstract from t_publication_id, t_author, t_publication where t_publication_id.publication_number=t_author.publication_number AND t_publication.publication_number = t_publication_id.publication_number AND t_publication_id.catalogue_number = '$cat_num';"; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); echo ""; echo ""; echo ""; echo ""; } pg_close($dbh); } ?>

Searching Database.....

'; $connstr = "dbname=mesonyx user=www host=localhost port=5432"; $dbh = @pg_pconnect($connstr); $stat = pg_exec($dbh, $sql); $row = pg_numrows($stat); for ($i = 0; $i < $row; $i++) { $data = pg_fetch_row($stat, $i); echo ''; } pg_close($dbh); if ($row != 0) { echo '
click to enlarge
AMNH $coll_num $data[2] $data[3] $data[4]
$data[0] $data[1]
COMMENTS ON IDENTIFICATION
$data[5]IDENTIFIED BY $data[7] $data[6]
DESCRIPTION
$data[1]
REMARKS $data[2]STATUS $data[3] DUPLICATE $data[4]
REFERENCED CATALOGUE/FIELD NUMBERS
$data[1] $data[0]
$data[2] $data[3]
EXPEDITION NAME/YEAR
$data[0]
$data[2] $data[1]
LOCALITY INFORMATION
LOCALITY NAME
$data[0] $data[1] $data[20]
TIME PERIOD
$data[2] $data[3] $data[4] $data[5] $data[6]
ROCK UNITS
$data[7] $data[8] $data[9] $data[10]
GEOGRAPHIC LOCATION
$data[11]
$data[12] $data[13] $data[14] $data[15]
STRATIGRAPHIC/LOCALITY NOTES
$data[16] $data[19]
DISCOVERY/EXPEDITION
$data[17]
PUBLICATION
$data[0], $data[1]. $data[2]. $data[3]. $data[4]. $data[5] $data[6]
$data[7]
$data[8]
Catalogue data and images retrieved from this database system are intended for educational and scholarly use only, and may not be used for any commercial purposes without prior consent from the American Museum of Natural History. Please note that electronic collections data are only proxies for the actual specimens, and although the specimen database is regularly checking for discrepancies, there is no guarantee of its accuracy. Please see this webpage if you wish to publish material obtained from this system. If you notice an error or omission please contact the webmaster.