/** * list newest tables for one anchor * * Example: * [php] * include_once 'tables/tables.php'; * $items = Tables::list_by_date_for_anchor(0, 10, '', 'section:12'); * $context['text'] .= Skin::build_list($items, 'compact'); * [/php] * * @param int the id of the anchor * @param int the offset from the start of the list; usually, 0 or 1 * @param int the number of items to display * @param string the list variant, if any * @return NULL on error, else an ordered array with $url => ($prefix, $label, $suffix, $icon) */ public static function list_by_date_for_anchor($anchor, $offset = 0, $count = 20, $variant = 'no_anchor') { global $context; // the request $query = "SELECT * FROM " . SQL::table_name('tables') . " WHERE (anchor LIKE '" . SQL::escape($anchor) . "') " . " ORDER BY edit_date DESC, title LIMIT " . $offset . ',' . $count; // the list of tables $output = Tables::list_selected(SQL::query($query), $variant); return $output; }