[dodgechargerfan]

I am relatively new to this stuff and I'm trying to wrap my head around a concept before I try a little bit of coding on my board.

SELECT field1 from prefix_table where field5 = 1;
SELECT field2 from prefix_table where field5 = 1;

Since I am trying to match on the same field, I figure there must be a way to get both pieces of data with one query.

I think I need to use an array, but can I just grab the fields I'm intersted in, or is it easier to move all of the data into an array and then just reference the fields with array[field1], array[field2].... etc...?