Image Record Click image for enlargement | ||
| ");
echo(" | ");
echo("ID | "); echo("" . $row["imageID"] . " | "); echo(""); echo("
| Title | "); echo("" . $row["imageName"] . " | "); echo("|
| Medium | "); echo("" . $row["mediumName"] . " | "); echo("|
| Book | "); echo("" . $row["authorName"] . ". "); echo("" . $row["title"] . ". "); echo $row["cityName"]; echo(" : "); echo $row["publisherName"]; echo(", "); echo $row["year"]; if ($row["page"] != "") { echo(". Page "); echo $row["page"]; } if ($row["plate"] != "") { echo(", Plate "); echo $row["plate"]; } echo(". | |
| Notes | "); echo(""); if ($row["addlNotes"] != "") { echo $row["addlNotes"]; echo(". "); } if ($row["curator"] != "") { echo $row["curator"]; } echo(" | "); echo("|
| Theme | "); echo("" . $row["topicName"] . " | "); echo("|
| Subjects | "); echo(""); $newID = $row["imageID"]; $result2 = @mysql_query("SELECT * FROM imagesubjects INNER JOIN subjects ON (imagesubjects.subjectID = subjects.subjectID) WHERE imagesubjects.imageID = '$newID'"); $num_rows = mysql_num_rows($result2); $i = 0; while ( $row2 = mysql_fetch_array($result2) ) { echo $row2["subjectName"]; if ( ++$i < $num_rows ) { echo (", "); } } echo(" | |
| | ||
| | ||