$update = mysql_query("UPDATE pictures SET picture_viewed = '$result['picture_viewed']' WHERE picture_number = '$picture' AND picture_album = '$album' LIMIT 1") or die(mysql_error());
I would imagine it has to do with '$result['picture_viewed']' because you are nesting single quotes... which is not allowed. For future reference, you need to use more descriptive thread titles and when you have an error... post it.
$update = mysql_query("UPDATE pictures SET picture_viewed = '".$result['picture_viewed']."' WHERE picture_number = '$picture' AND picture_album = '$album' LIMIT 1") or die(mysql_error());
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.