Subversion-Projekte lars-tiefland.ci

	public function get($id)

	{

		$sql = "SELECT

				*

			FROM

				directory

			WHERE

				id=".$id."

		";

		$res = $this->db->query($sql);

		$row = $res->unbuffered_row('array');

		$sql = "SELECT

				meta_content,

				meta_type

			FROM

				metatags

			WHERE

				table_foreign='directory'

			AND

				data_foreign=".$id."

		";

		$res = $this->db->query($sql);

		while ($metaRow = $res->unbuffered_row('array'))

		{

			$row[$metaRow["meta_type"]] = $metaRow["meta_content"];

		}

		return $row;

	}