Create date array from database

[TCovert]

One of the fields in my database is named "pubdate" which contains the date that record was published. What I want to do is pull five dates from the databse that are previous to todays date, and then write that array to a file. How would I pull this array?

It is easy to pull the last 5 records and their dates...but, I need the last five days dates in the array.

Any ideas?

[TTT]

select foo from table where day < $daynow-5

[TCovert]

What code would I use to display this result in an array?

[TCovert]

Does anyone have any idea?