]> http://www.publicampaign.org/pcnewswire Comments for "Latest News From the Wire" en http://www.publicampaign.org/pcnewswire <?php $result = pager_query(db_rewrite_sql("SELECT n.*, a.*, af.nid AS feednid FROM {node} n INNER JOIN {aggregator2_item} a ON n.nid = a.nid INNER JOIN {aggregator2_feed} af ON a.fid = af.nid WHERE n.type = 'aggregator2_item' AND n.status = 1 ORDER BY n.created DESC"), 15); while ($bing2 = db_fetch_object($result)) { $feedtitle = node_load(array('nid' => $bing2->feednid)); $date = format_date($bing2->created, 'custom', 'l, F j, Y'); if ($date != $last) { $last = $date; $bings2[] = '<h2 class="date-title">'.$date.'</h2>'; } $bings2[] = '<div class="news-item-main"><span class="blog-title">'; $bings2[] = l($bing2->title,'node/'.$bing2->nid); $bings2[] = '</span><br />'; $bings2[] = '<span class="blog-info">'; $bings2[] = $feedtitle->title.'&nbsp; - &nbsp;'; $bings2[] = format_date($bing2->created, 'custom', 'M d, g:i A'); $bings2[] = '</span><br />'; $bings2[] = '<span class="blog-readmore"><p><img src="/sites/www.publicampaign.org/themes/pcc3/images/readmore.png" />'; $bings2[] = l(t('read more'), "node/$bing2->nid"); $bings2[] = '</p></span><img src="/sites/www.publicampaign.org/themes/pcc3/images/news_line.png" /></div>'; } $output = '<div id="newspage">'; $output .= theme_news_list($bings2); $output .= '</div>'; $output .= theme('pager', NULL, 15); echo $output; ?> Thu, 20 Jul 2006 07:06:48 -0500