';
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 ' |