converting to mvc

[eluser]redraw[/eluser]
guys.. need help here
could you tell me how to convert this query to mvc (model view controller) on codeigniter?
here the query :

SELECT ms_program.program
FROM
dbrsmp.ms_user
INNER JOIN dbrsmp.ms_akses
ON (ms_user.kode_id = ms_akses.kode_id)
INNER JOIN dbrsmp.ms_program
ON (ms_akses.id_program = ms_program.id_program) WHERE ms_user.kode_id = '1'


Thanks a lot

[eluser]Developer13[/eluser]
There would be no difference in the query. MVC is a design pattern. In and of itself, it doesn't have any effect on database queries.

[eluser]redraw[/eluser]
thanks for your answer. sorry for my bad english
i confused to convert it to model, view and controller

example :
query = SELECT ms_program.program
FROM
become :
$this->db->select(program)->from('ms_program','content')

query = dbrsmp.ms_user
INNER JOIN dbrsmp.ms_akses
ON (ms_user.kode_id = ms_akses.kode_id)
INNER JOIN dbrsmp.ms_program
ON (ms_akses.id_program = ms_program.id_program) WHERE ms_user.kode_id = ‘1’

become : ??

thanks

[eluser]Developer13[/eluser]

Code:

$this->db->select('field1, field2, field3');
$this->db->join('table2', 'table2.col1 = table1.col1');
$this->db->join('table3', 'table3.col2 = table2.col2');
$query = $this->db->get('table1');

Code:

$this->db->select('field1, field2, field3'); $this->db->join('table2', 'table2.col = table1.col'); $this->db->join('table3', 'table3.col = table2.col'); $query = $this->db->get('table1');

You can find examples in the documentation here:
http://ellislab.com/codeigniter/user-gui...ecord.html

You can also just do:

Code:

$sql = 'SELECT field1, field2, field3 FROM table1 JOIN table2 ON table2.col1 = table1.col1 JOIN table3 ON table3.col2 = tabl32.col2';
$query = $this->db->query($sql);

More about that here:
http://ellislab.com/codeigniter/user-gui...eries.html

[eluser]redraw[/eluser]
thank you so much for the fast response.. Developer13