aggregator_feed_items_load
- Versions
- 6
aggregator_feed_items_load($sql)- 7
aggregator_feed_items_load($type, $data = NULL)
Load feed items by passing a SQL query.
Parameters
$sql The query to be executed.
Return value
An array of the feed items.
Code
modules/aggregator/aggregator.pages.inc, line 83
<?php
function aggregator_feed_items_load($sql) {
$items = array();
if (isset($sql)) {
$result = pager_query($sql, 20);
while ($item = db_fetch_object($result)) {
$result_category = db_query('SELECT c.title, c.cid FROM {aggregator_category_item} ci LEFT JOIN {aggregator_category} c ON ci.cid = c.cid WHERE ci.iid = %d ORDER BY c.title', $item->iid);
$item->categories = array();
while ($item_categories = db_fetch_object($result_category)) {
$item->categories[] = $item_categories;
}
$items[$item->iid] = $item;
}
}
return $items;
}
?>