Include "selected" news item instead of by date
3 posts by 2 authors in: Forums > CMS Builder
Last Post: February 1, 2011 (RSS)
By ScottL - January 31, 2011
I'm currently including the two newest 'news' items on the main page with this:
list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'allowSearch' => true,
'orderBy' => "createdDate DESC",
'limit' => 2,
How can I allow the site owner to select which two items to include instead of doing it by the two newest dates?
The reason for this is they may want to go back and display an older story instead of the two newest.
Thanks
list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'allowSearch' => true,
'orderBy' => "createdDate DESC",
'limit' => 2,
How can I allow the site owner to select which two items to include instead of doing it by the two newest dates?
The reason for this is they may want to go back and display an older story instead of the two newest.
Thanks
Re: [thinkng] Include "selected" news item instead of by date
By Jason - January 31, 2011
Hi,
What you can do is have a check box in your news section called something like "news_selected". You can then change your query like this:
Note that if the user selects more than 2, it will still only return the first 2.
Hope this helps.
What you can do is have a check box in your news section called something like "news_selected". You can then change your query like this:
list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'allowSearch' => true,
'where' => "news_selected = 1",
'limit' => 2,
));Note that if the user selects more than 2, it will still only return the first 2.
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/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Include "selected" news item instead of by date
By ScottL - February 1, 2011
Works perfect. Thanks Jason.