+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: help me about query db new from query db old (/showthread.php?tid=54923)
help me about query db new from query db old - El Forum - 10-01-2012
[eluser]Unknown[/eluser]
select a.* , b.*, c.*, d.* ,(select count(*) from simdik_nilai_akhir_siswa where jadwal_id = a.id_jadwal) as peserta
from simdik_jadwal a join simdik_kelas b on a.kelas_id = b.id join simdik_pegawai c on a.pengajar_id = c.no_induk join simdik_matapelajaran d on a.pelajaran_id= d.id
question is :
what can I do? if I want change this query to query in codeigniter.
attentions :
thanks and God Bless You for all PHP developer
I am Newbie but smart
