/** * Load rows from a DB table (limited and sorted by method parameters) * * @param $table db table to use * @param string $start start record for limit * @param string $limit number of records requested (limit) * @param string $orderColumn column to order rows by * @param string $order order type * @return object db rows */ function loadMany($table, $start = '', $limit = '', $orderColumn = '', $order = 'ASC') { global $_dibi; return $_dibi->fetchAll("SELECT *\n FROM `" . CLE_Ibdi::getNameOfTable($table) . "`\n %if ", $orderColumn, "\n ORDER BY `" . $orderColumn . "` " . $order . "\n %end\n %if", $limit, "LIMIT " . (int) $start . ',' . (int) $limit); }