Subversion-Projekte lars-tiefland.ci

Revision

Revision 1587 | Revision 1590 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1587 Revision 1589
Zeile 9... Zeile 9...
9
 * Herstellerkatalog_model
9
 * Herstellerkatalog_model
10
 * 
10
 * 
11
 * @package WebanOS CI
11
 * @package WebanOS CI
12
 * @author Lars Tiefland
12
 * @author Lars Tiefland
13
 * @copyright 2016
13
 * @copyright 2016
14
 * @version $Id: Herstellerkatalog_model.php 1587 2016-11-19 20:49:59Z lars $
14
 * @version $Id: Herstellerkatalog_model.php 1589 2016-11-19 20:51:29Z lars $
15
 * @access public
15
 * @access public
16
 */
16
 */
17
class Herstellerkatalog_model extends CI_Model
17
class Herstellerkatalog_model extends CI_Model
18
{
18
{
19
	/**
19
	/**
Zeile 43... Zeile 43...
43
				$sql = "SELECT
43
				$sql = "SELECT
44
						id,
44
						id,
45
						name
45
						name
46
					FROM
46
					FROM
47
						Herstellerkatalog
47
						Herstellerkatalog
-
 
48
					ORDER BY
-
 
49
						id
48
				";
50
				";
49
				$res = $this->db->query($sql);
51
				$res = $this->db->query($sql);
50
				$result = $res->result_array();
52
				$result = $res->result_array();
51
				break;
53
				break;
52
			case "dropdown":
54
			case "dropdown":
Zeile 54... Zeile 56...
54
				$sql = "SELECT
56
				$sql = "SELECT
55
						id,
57
						id,
56
						name
58
						name
57
					FROM
59
					FROM
58
						Herstellerkatalog
60
						Herstellerkatalog
-
 
61
					ORDER BY
-
 
62
						id
59
				";
63
				";
60
				$res = $this->db->query($sql);
64
				$res = $this->db->query($sql);
61
				while ($row = $res->unbuffered_row('array'))
65
				while ($row = $res->unbuffered_row('array'))
62
				{
66
				{
63
					$result[$row["id"]] = $row["name"];
67
					$result[$row["id"]] = $row["name"];