When I get all the records from the photos table, I am using a web page to display only the first record, then, if the user hits a next link then the user should be able to see the next record (next picture) and so on, I do not want to do a select every time the user hits next or back to get the picture name and then display it
Why? You're selecting one record - it will be quick as long as you're db is indexed correctly.
Is there anyway to do a one SELECT statement, save them in a matrix and then just go thru it. I am using the same web page to display all pictures, e.g. the next link points to the same web page where the first picture was displayed, is it possible to pass a matrix variable ?
Sure. Stuff it all in an array and then save it in the session.
--
Postgresql & php tutorials
http://www.designmagick.com/