Jump to:
3070 Posts in 869 Topics by 651 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 879 Views |
-
add wher clause in latest news
23 October 2009 at 7:54pm
Hi!
I follow guide to show in my home page the last 3 news. Is possible add a where clause to show only news that have in db the field 'type' (I add this field in my db) = economy?
function LatestNews($num=3) {
$news = DataObject::get_one("NewsHolder");
return ($news) ? DataObject::get("NewsPage", "ParentID = $news->ID", "Date DESC", "", $num) : false;
}help please..
-
Re: add wher clause in latest news
23 October 2009 at 8:02pm
Something like this should work:
function LatestNews($num=3) {
$news = DataObject::get_one("NewsHolder");
return ($news) ? DataObject::get("NewsPage", "ParentID = $news->ID AND type = 'economy'", "Date DESC", "", $num) : false;
}
| 879 Views | ||
|
Page:
1
|
Go to Top |
