How to pull data from a database

I have a picture gallery script and I want to display a list of all the albums that are unpublished (this is indicated by "0" instead of one, but this does not matter). I want to pull columns like this:

album_id
main_photo_id
content_source_id
title
description
gallery_url

I will be using PDO (as far as I know this is the best way of achieving that) but I am wondering if I should store all these items in an array and work with that from then on or how this should be done? As far as that, I want to display all the albums with pagination and also be able to select the albums with certain content_source_id and so on. Would I work with that array of values and select it from there or would I run another query on the database (like a html select form to pick the content_source_id, and this would be getting it from the "initial array", pulled from the database just one time at the begiing or would this all be query based?).

Thanks.