Display Multi List titles but not current one

3 posts by 3 authors in: Forums > CMS Builder
Last Post: August 20, 2010   (RSS)

By (Deleted User) - August 20, 2010

Hello,

I have a news multi list page. On the detail page I have the following:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/finishs/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
list($news_pagesRecords, $news_pagesMetaData) = getRecords(array(
'tableName' => 'news_pages',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',));
list($onews_pagesRecords, $onews_pagesMetaData) = getRecords(array(
'tableName' => 'news_pages',));
$news_pagesRecord = @$news_pagesRecords[0];
if (!$news_pagesRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;}?>

The page is displayed as normal. In the sidebar I would like to list all the Other news items but NOT the current one as obviously the visitor is on it.

In the sidebar I have the following:
<ul class="latestnews">
<?php foreach ($onews_pagesRecords as $record): ?>
<li>
<img src="<?php echo $record['sidebar_list_url'] ?>" alt="<?php echo $record['list_title'] ?>" class="alignleft imgbox"/>
<span class="blogtitle"><a href="/news/<?php echo $record['url_keywords'] ?>-<?php echo $record['num'] ?>"><?php echo $record['list_title'] ?></a></span>
<p><?php echo $record['list_content'] ?></p>
</li>
<?php endforeach ?>
</ul>

How do I change the sidebar code to show all the latest news items other than the current one?

Thanks Jono

Re: [jonoc73] Display Multi List titles but not current one

By Chris - August 20, 2010 - edited: August 20, 2010

Hi Jono,

If you're not using $onews_pagesRecords for anything other than the sidebar, it would be easy enough to add a WHERE filter to not return the main detail page record. To do this, you'll need to move your code around a little so that your "Record not found" check runs before you try to use $news_pagesRecord['num'] for the WHERE. New code in red:

list($news_pagesRecords, $news_pagesMetaData) = getRecords(array(
'tableName' => 'news_pages',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));

$news_pagesRecord = @$news_pagesRecords[0];
if (!$news_pagesRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}

list($onews_pagesRecords, $onews_pagesMetaData) = getRecords(array(
'tableName' => 'news_pages',
'where' => mysql_escapef('num <> ?', $news_pagesRecord['num']),
));

I hope this helps! Please let me know if you have any questions.
All the best,
Chris