/**

• Custom content function.
• Set beginning and end dates, retrieve posts from database
• saved in that time period.
• @return
• A result set of the targeted posts. */ function currentpostscontents(){ //Get today's date. $today = getdate(); //Calculate the date a week ago. $starttime = mktime(0, 0, 0,$today['mon'],($today['mday'] - 7), $today['year']); //Get all posts from one week ago to the present. $endtime = time();

//Use Database API to retrieve current posts.
$query = dbselect('node', 'n')
->fields('n', array('nid', 'title', 'created'))
->condition('status', 1) //Published.
->condition('created', array($starttime, $end_time), 'BETWEEN')
->orderBy('created', 'DESC') //Most recent first.
->execute();
return $query;

}
(Remember not to include the closing ?> in your code.)