Global Variable

[eluser]jupiter1031[/eluser]

Code:

class Projects_model extends CI_Model {
    
    private $q_string;
    
        function __construct()
    {
        parent::__construct();
        

    }
    

    function getProjects()
    {
        global $q_string;
        $q = $this->db->get('projects','desc');
        $q_string="SELECT *  FROM projects ORDER BY prj_year DESC, prj_year_sort ASC";
        $q= $this->db->query($q_string);
        if ($q->num_rows() > 0) {
            foreach ($q-[code]

>result() as $row)
{
$data[] = $row;
}
}
$q->free_result();
return $data;
}
function ooProjects()
{
// this does not work even I set $q_string before in function getProjects() or
// getProjectYears

global $q_string;
$q= $this->db->query($q_string);
if ($q->num_rows() > 0) {
}
return $q;
}

function getProjectYears()
{
global $q_string;
$year_from = $this->input->post('year_from');
$year_to = $this->input->post('year_to');
$q_string="SELECT * FROM projects where prj_year >=".$year_from." and prj_year <= ".$year_to.
" ORDER BY prj_year DESC, prj_year_sort ASC";
$q= $this->db->query($q_string);
if ($q->num_rows() > 0)
{
foreach ($q->result() as $row)
{
$data[] = $row;
}
return $data;
$q->free_result();
}
}[/code]