Subversion-Projekte lars-tiefland.ci

<?php

class Artikel_model extends CI_Model
{
        public function get_list($dir=-1)
        {
                $sql="SELECT
                                *
                        FROM
                                artikel
                        WHERE
                                father=".$dir."
                        ORDER BY
                                rang
                ";
                $res = $this->db->query($sql);
                $items = $res->result_array();
                return $items;
        }
        
        public function get($id)
        {
                $sql="SELECT
                                *
                        FROM
                                artikel
                        WHERE
                                id=".$id."
                ";
                $res = $this->db->query($sql);
                $row = $res->unbuffered_row('array');
                return $row;
        }
}