Open almezi opened 6 years ago
Sql In Problem 2 :
select s.nama,s.nis,if((select ROUND(nilai,2) from pmp where nis=s.nis and idmapel='BIND1' and semester="2" and thnajar='2015/2016') is null,'',(select ROUND(nilai,2) from pmp where nis=s.nis and idmapel='BIND1' and semester="2" and thnajar='2015/2016')) as nilai, if((select round(skor,2) from pmp where nis=s.nis and idmapel='BIND1' and semester="2" and thnajar='2015/2016') is null,'',(select round(skor,2) from pmp where nis=s.nis and idmapel='BIND1' and semester="2" and thnajar='2015/2016')) as skor from siswa s join kelas_siswa ks on(ks.nis=s.nis) join kelas k on(ks.idkelas=k.idkelas) where k.idkelas='1j' and ks.thnajar='2015/2016'
Have result Tabel PMP did not exist
Sql in Problem 1:
select distinct s.nis, s.nama, b.nama bab, b.idbab idbab, if((select round(nilai,2) from evaluasi where idbab=' ' and nis=s.nis and thnajar='2015/2016' and semester=1) is null,'',(select round(nilai,2) from evaluasi where idbab=' ' and nis=s.nis and thnajar='2015/2016' and semester=1)) as nilai from siswa s join kelas_siswa ks on(ks.nis=s.nis) join kelas k on(ks.idkelas=k.idkelas) join bab b on(b.idkelas=k.idkelas) where k.idkelas='1j' AND b.idbab='' and ks.thnajar='2015/2016' and b.semester=1 and b.thanjar='2015/2016'
In HeidiSql Showup the table but in the m_database still error fatal Call to a member function result() on boolean
di tab"Evaluasi PMP " terdapat masalah di dalam tab saat memasuki pengimputan nilai siswa baik itu evaluasi maupun PMP Bagian Evaluasi Call to a member function result() on boolean in C:\xampp\htdocs\WebApps-arrafi\application\views\guru_input_pilihsiswa.php:54
Bagian PMP Call to a member function result() on boolean in C:\xampp\htdocs\WebApps-arrafi\application\views\guru_inputpmp_pilihsiswa.php:175 Stack trace: #0