menegecek query

cara mengecek query benar atau tidak adalah tanda == (dua sama dengan) sebagai penanda ny



$tampil=mysql_query("SELECT nilai_magister.nim
FROM nilai_magister
WHERE nilai_magister.semes='00001 TH 2013/2014' GROUP BY nilai_magister.nim ");
$z=mysql_fetch_array($tampil);
//$zz=$z['nim'];
while ($t=mysql_fetch_array($tampil))
{

$nimm=$t['nim'];
$cekips=mysql_query("SELECT nim, nilai1,kk, sks, sum(nilai_bobot*sks) as total_am,
SUM(sks) as ttl_sks,
nilai_bobot as nilai_mk
FROM (select nim,kode_mk,nilai as nilai1,
nilai_magister.kode_mk AS kk,
(if(nilai='A',4,
if(nilai='B',3,
if(nilai='C',2,
if(nilai='D',1,0))))) as nilai_bobot
FROM nilai_magister
WHERE  nilai_magister.semes='00001 TH 2013/2014' and nilai_magister.nim='$nimm')
a INNER JOIN  kurstol_s2 on a.kode_mk=kurstol_s2.kode_mk  GROUP BY nim ");


$ns=mysql_fetch_array($cekips);

$j=$ns['total_am'];


echo"<tr >
<td>$t[nim]</td>
<td>$j
==
SELECT nim, nilai1,kk, sks, sum(nilai_bobot*sks) as total_am,
SUM(sks) as ttl_sks,
nilai_bobot as nilai_mk
FROM (select nim,kode_mk,nilai as nilai1,
nilai_magister.kode_mk AS kk,
(if(nilai='A',4,
if(nilai='B',3,
if(nilai='C',2,
if(nilai='D',1,0))))) as nilai_bobot
FROM nilai_magister
WHERE  nilai_magister.semes='00001 TH 2001/2002' and nilai_magister.nim='$nimm')
a INNER JOIN  kurstol_s2 on a.kode_mk=kurstol_s2.kode_mk  GROUP BY nim
</td>

</tr>";


}

Share on Facebook

Share on Twitter

Share on Google+

Share on LinkedIn

Subscribe to receive free email updates: