I'm not a wiz either, but.....
Just change the output to your likings....
// Specify the Group(id) you want to read the news from or 0 for all groups
$group = 0;
// Specify number of newsitems
$limit=10;
// Specify read more text
$readmore = "Read more";
// Specify Older news text
$oldernews = "Older news";
// Query for obtaining stuff from a group
$query = "SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE group_id = $group and active = 1 ORDER BY position DESC LIMIT 0, 10;";
// Query for all groups ;)
if ($group<1 ) {
$query = "SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE active = 1 ORDER BY position DESC LIMIT 0, 10;";
}
// No changes needed here, maybe for output!
global $database;
$result = $database->query($query);
$total = $result->numRows(); // how many items are there?
if ($total>1) { // at least 2 needed for 2 news items
$data = $result->fetchRow() ; // get left item
$data2 = $result->fetchRow() ; // get right item
echo '<table width=100%>';
echo '<tr><td width=50%>'.$data['title'].'</td><td width=50%>'.$data2['title'].'</td></tr>';
echo '<tr><td>'.$data['content_short'].'</td><td>'.$data2['content_short'].'</td></tr>';
echo '<tr><td></td><td></td></tr>';
echo '<tr><td><a href="'.WB_URL.PAGES_DIRECTORY.$data['link'].PAGE_EXTENSION.'">'.$readmore.'</a></td>';
echo '<td><a href="'.WB_URL.PAGES_DIRECTORY.$data2['link'].PAGE_EXTENSION.'">'.$readmore.'</a></td></tr>';
echo '</table>';
}
// Next show the rest
if ($total>2) { // are there any left?
echo '<br><br><table><tr><td colspan=2>'.$oldernews.'</td></tr>';
echo '<tr><td>Date</td><td>Subject</td></tr>';
while ($data = $result->fetchRow()) {
echo '<tr><td>'.strftime( "%d-%m-%Y",$data['posted_when']).'</td>';
echo '<td><a href="'.WB_URL.PAGES_DIRECTORY.$data['$link'].PAGE_EXTENSION.'">'.$data['title'].'</a></td></tr>';
}
echo '</table>';
}
WebsiteBaker Community Forum
