/lenasys/trunk

<?php

	Class examplesmodel extends CI_Model

	{

		/* Loads category names for menu */

		function getTitles($user)

		{

			$this -> db -> select('Categories.categoryName, Categories.courseID');

			$this -> db -> from('Categories');

			$this -> db -> join('StudentCourseRegistrations', 'Categories.courseID = StudentCourseRegistrations.courseID'); 

			$this -> db -> where('StudentCourseRegistrations.username', $user); 

			$this -> db -> order_by("orderNr", "asc"); 

		/* 	$this -> db -> where('StudentCourseRegistrations.courseID', 'd1popcrn');  

		* 	Line is disabled for now because of testing purposes.

		*	Will be modified to be used with parameter in function.

		*/

			$query = $this -> db -> get();

			return $query->result();

		}

		/* Loads categorys & subcategorys for body */

		function getBody($categoryName)

		{

			$this -> db -> select('subCategoryName');

			$this -> db -> from('SubCategories'); 

			$this -> db -> where('categoryName', $categoryName); 

			$query = $this -> db -> get();

			return $query->result();

		}

		/* Loads examples for categorys */

		function getExamples($subCategoryName)

		{

			$this -> db -> select('exampleName');

			$this -> db -> from('Examples'); 

			$this -> db -> where('subCategoryName', $subCategoryName); 

			$query = $this -> db -> get();

			return $query->result();

		}

	}

?>