';
echo '';
if ($file == null)
{
echo " |
---|
ERROR: No image file found! |
";
}
if ($file != null)
{
$sql = "select image_number, image_id, title, genus, species, catalogue_number, medium, image_size, publication_number, artist_last_name, artist_first_name, image_date, image_description, file_name from t_image where file_name = '$file';";
$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 'Image Number: | ';
echo $data[0];
echo ' |
';
echo 'Image ID: | ';
echo $data[1];
echo ' |
';
echo 'Title: | ';
echo $data[2];
echo ' |
';
echo 'Genus: | ';
echo $data[3];
echo ' |
';
echo 'Species: | ';
echo $data[4];
echo ' |
';
echo 'Catalogue Number: | AMNH ';
echo $data[5];
echo ' |
';
echo 'Medium: | ';
echo $data[6];
echo ' |
';
echo 'Image Size: | ';
echo $data[7];
echo ' |
';
echo 'Publication Number: | ';
echo $data[8];
echo ' |
';
echo 'Artist Name: | ';
echo $data[10];
echo ' ';
echo $data[9];
echo ' |
';
echo 'Image Date: | ';
echo $data[11];
echo ' |
';
echo 'Image Description: | ';
echo $data[12];
echo ' |