class Collection extends AmortizeInterface { protected $table_name = 'collections'; protected $table_columns = array('name' => "tinytext"); protected $autoprimary = TRUE; } class Book extends AmortizeInterface { protected $table_name = 'myBooks'; protected $table_columns = array('isbn' => "varchar(20)", 'author' => "tinytext", 'title' => "tinytext", 'pubyear' => "year"); protected $autoprimary = TRUE; } $pub = new collection(1); dbm_debug('heading', "Loading \"{$pub->name}\" from the first example."); dbm_debug('info', "Default ordering"); $books = $pub->getLinks("Book"); foreach ($books as $book) { dbm_debug('data', "{$book->title} ({$book->pubyear})"); } dbm_debug('info', "Order by year ascending"); $books = $pub->getLinks("Book", "ORDER BY pubyear ASC"); foreach ($books as $book) { dbm_debug('data', "{$book->title} ({$book->pubyear})"); } dbm_debug('info', "Order by year descending"); $books = $pub->getLinks("Book", "ORDER BY pubyear DESC"); foreach ($books as $book) { dbm_debug('data', "{$book->title} ({$book->pubyear})"); } dbm_debug('info', "Order by year ascending with limit (kind of a hack)"); $books = $pub->getLinks("Book", "ORDER BY pubyear ASC LIMIT 1");