Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $getArtwork1_sql = "SELECT * FROM artwork WHERE artworkId = '$i'";
- $getArtwork1_query = mysql_db_query($dbname, $getArtwork1_sql, $dbh);
- while ($row2 = mysql_fetch_array($getArtwork1_query)) {
- $artistId = $row2["artistId"];
- $title = $row2["title"];
- $title_upper = strtoupper("$title");
- $date = $row2["date"];
- $dimensions = $row2["dimensions"];
- $inscription = $row2["inscription"];
- $description = $row2["description"];
- $provenance = $row2["provenance"];
- $bibliography = $row2["bibliography"];
- $accesionId = $row2["accesionId"];
- $photoCredit = $row2["photoCredit"];
- }
- $getArtwork2_sql = "SELECT firstName,lastName FROM artist WHERE artistId = '$artistId'";
- $getArtwork2_query = mysql_db_query($dbname, $getArtwork2_sql, $dbh);
- while ($row2 = mysql_fetch_array($getArtwork2_query)) {
- $firstName = $row2["firstName"];
- $lastName = $row2["lastName"];
- }
Add Comment
Please, Sign In to add comment