+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: active record : SELECT [...] FROM (SELECT [...]) ? (/showthread.php?tid=16683)
active record : SELECT [...] FROM (SELECT [...]) ? - El Forum - 03-13-2009
[eluser]m_ologin[/eluser]
Hi community,
How can I create the active record query for this :
Code:
SELECT sum(s1) AS max_pts FROM (SELECT max(a.nb_points) AS s1 FROM t_ans a LEFT JOIN t_qu q ON a.id_qu = q.id WHERE a.is_correct=1 GROUP BY a.id_question) AS st1active record : SELECT [...] FROM (SELECT [...]) ? - El Forum - 03-13-2009
[eluser]TheFuzzy0ne[/eluser]
I'm not sure if you can to be honest...
active record : SELECT [...] FROM (SELECT [...]) ? - El Forum - 03-13-2009
[eluser]m_ologin[/eluser]
Ok so do I need to sanitize my data before and just do a simple query?
active record : SELECT [...] FROM (SELECT [...]) ? - El Forum - 03-13-2009
[eluser]TheFuzzy0ne[/eluser]
I would say so, yes. Don't forget to use $this->db->escape();
active record : SELECT [...] FROM (SELECT [...]) ? - El Forum - 03-13-2009
[eluser]m_ologin[/eluser]
Allright. Thanks for your help.