Display Results of Two filters on the Same List Page

14 posts by 3 authors in: Forums > CMS Builder
Last Post: February 10, 2011   (RSS)

By northernpenguin - February 8, 2011

Thanx Jason

Its attached.
--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
Attachments:

recentnewsarticles_002.php 4K

Re: [northernpenguin] Display Results of Two filters on the Same List Page

By Jason - February 9, 2011

Hi,

What you need to do is when you're selecting your lists of records, check to see if a record has already been selected. If not, get the first record in your list:

<?php
list($recent_news_articlesRecords, $recent_news_articlesMetaData) = getRecords(array(
'tableName' => 'recent_news_articles',
'where' => 'datediff(publishDate, curdate()) > -365',
'orderBy' => 'publishDate DESC',
));

if(!$recent_news_articlesRecord) {
$recent_news_articlesRecord = $recent_news_articlesRecord[0]; //get first record if specific record wasn't selected
}
?>

<?php
list($newsArchivesRecords, $newsArchivesMetaData) = getRecords(array(
'tableName' => 'recent_news_articles',
'where' => 'datediff(publishDate, curdate()) < -365',
'orderBy' => 'publishDate DESC',
));

if(!$newsArchivesRecord) {
$newsArchivesRecord = $newsArchivesRecords[0]; //get first record if specific record wasn't selected
}

?>

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By northernpenguin - February 9, 2011

Jason: worked great! Thank you. I did find one minor typo (in blue below).

IT does it again!!

Ragi

Hi,

What you need to do is when you're selecting your lists of records, check to see if a record has already been selected. If not, get the first record in your list:

<?php
list($recent_news_articlesRecords, $recent_news_articlesMetaData) = getRecords(array(
'tableName' => 'recent_news_articles',
'where' => 'datediff(publishDate, curdate()) > -365',
'orderBy' => 'publishDate DESC',
));

if(!$recent_news_articlesRecord) {
$recent_news_articlesRecord = $recent_news_articlesRecords[0]; //get first record if specific record wasn't selected
}
?>

<?php
list($newsArchivesRecords, $newsArchivesMetaData) = getRecords(array(
'tableName' => 'recent_news_articles',
'where' => 'datediff(publishDate, curdate()) < -365',
'orderBy' => 'publishDate DESC',
));

if(!$newsArchivesRecord) {
$newsArchivesRecord = $newsArchivesRecords[0]; //get first record if specific record wasn't selected
}

?>

Hope this helps

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke