Guest User

Untitled

a guest
Apr 19th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1.  
  2. $getArtwork1_sql = "SELECT * FROM artwork WHERE artworkId = '$i'";
  3. $getArtwork1_query = mysql_db_query($dbname, $getArtwork1_sql, $dbh);
  4.  
  5. while ($row2 = mysql_fetch_array($getArtwork1_query)) {
  6.  
  7. $artistId = $row2["artistId"];
  8. $title = $row2["title"];
  9. $title_upper = strtoupper("$title");
  10. $date = $row2["date"];
  11. $dimensions = $row2["dimensions"];
  12. $inscription = $row2["inscription"];
  13. $description = $row2["description"];
  14. $provenance = $row2["provenance"];
  15. $bibliography = $row2["bibliography"];
  16. $accesionId = $row2["accesionId"];
  17. $photoCredit = $row2["photoCredit"];
  18.  
  19. }
  20.  
  21. $getArtwork2_sql = "SELECT firstName,lastName FROM artist WHERE artistId = '$artistId'";
  22. $getArtwork2_query = mysql_db_query($dbname, $getArtwork2_sql, $dbh);
  23.  
  24. while ($row2 = mysql_fetch_array($getArtwork2_query)) {
  25.  
  26. $firstName = $row2["firstName"];
  27. $lastName = $row2["lastName"];
  28.  
  29. }
Add Comment
Please, Sign In to add comment