Joomla 1.6 search finish publishing date

[NAmeviolated]

 

Hey,

 

I have a module that can input custom html/php, and within this I want to put a link ie "Closing soon", that when clicked on displays search results for articles that will hit Finish publishing (publish_down), within 7 days.

 

Now I know I need to create the link, pull the data from publish_down in the sql database, compare it to see if it has less than a certain number of seconds left, and if it does display it when the link is clicked.  But have no idea how to go from there code wise. 

 

Any ideas on where to start would be appreciated.