Drupal e-Commerce

• View documentation
• List references

Definition

aggregator_feed_items_load($sql)
drupal-cvs/modules/aggregator/aggregator.pages.inc, line 83

Description

Load feed items by passing a SQL query.

Parameters

$sql The query to be executed.

Return value

An array of the feed items.

Code

<?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;
}
?>