$sqlb = mysql_query("SELECT \r\n\tCOUNT(id_upload) as 'M',\r\n\tCOUNT(IF(jenis_rev=0,1,null)) as 'Q',\r\n COUNT(IF(jenis_rev=1,1,null)) as 'R',\r\n COUNT(IF(hasil='0',1,null)) as 'S',\r\n COUNT(IF(hasil=1,1,null)) as 'T' \r\n \tfrom upload_mhs, review_praoutline WHERE id=id_upload and id_upload='{$result['id_upload']}'");
$row = mysql_fetch_array($sqlb);
$status = $result['status_review'] == "1" ? "Opened" : "Closed";
$tgl_indo = tgli($result['A']);
$cetaknm = nama($result['NIM']);
echo "\r\n <td align='center'><img src='../images/show.jpg'></td>\r\n <td><a href='recent1.php?mode=rep&id_jud={$result['id']}#bottom'>{$result['judul_praoutline']}</a></td>\r\n <td align='center'>{$row['M']}</td>\r\n <td align='center'>{$row['R']}<br><br>Y : <font color=#01016F><b>{$row['T']}</b></font> -- N : <font color=#FA0303><b>{$row['S']}</b></font></td>\r\n <td width='14%'>\r\n Oleh : <font color=#583000><b>{$result['NIM']}</b></font><br><font color=#072dba><b>{$cetaknm}</b></font><br>\r\n Tanggal : {$tgl_indo}<br>\r\n Waktu : {$result['B']}<br>\r\n Status : <font color=#7BC409><b>{$status}</b></font>\r\n </td>\r\n <td width='2%'><a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>";
$no++;
}
echo "\r\n <tr colspan='6'>\r\n\r\n </tr>";
echo "</table>";
} else {
$sqld = "SELECT DISTINCT(id_upload) as 'new', \r\n\tjudul_praoutline, \r\n\tNIM, status_review, \r\n upload_mhs.tanggal as 'A',\r\n upload_mhs.waktu as 'B', \r\n\tCOUNT(id_upload) as 'M',\r\n\tCOUNT(IF(jenis_rev=0,1,null)) as 'Q',\r\n COUNT(IF(jenis_rev=1,1,null)) as 'R',\r\n COUNT(IF(hasil='0',1,null)) as 'S',\r\n COUNT(IF(hasil=1,1,null)) as 'T'\r\n\tFROM review_praoutline, upload_mhs \r\n\tWHERE id_upload NOT IN (SELECT id_upload FROM review_praoutline, upload_mhs WHERE id=id_upload and jenis_rev='1' and reviewer='{$initid}' ORDER by id_upload) \r\n\tand id=id_upload \r\n\tand status_review='1' GROUP by new";
$hasild = mysql_query($sqld);
//$jum = mysql_num_rows($hasil);
$no = 1;
while ($resultd = mysql_fetch_array($hasild)) {
$status = $resultd['status_review'] == "1" ? "Opened" : "Closed";
$tgl_indo = tgli($resultd['A']);
$cetaknm = nama($resultd['NIM']);
echo "\r\n <td align='center'><img src='../images/show.jpg'></td>\r\n <td><a href='recent1.php?mode=nodes&id_jud={$resultd['new']}'>{$resultd['judul_praoutline']}</a></td>\r\n <td align='center'>{$resultd['M']}</td>\r\n <td align='center'>{$resultd['R']}<br><br>Y : <font color=#01016F><b>{$resultd['T']}</b></font> -- N : <font color=#FA0303><b>{$resultd['S']}</b></font></td>\r\n <td width='14%'>\r\n Oleh : <font color=#583000><b>{$resultd['NIM']}</b></font><br><font color=#072dba><b>{$cetaknm}</b></font><br>\r\n Tanggal : {$tgl_indo}<br>\r\n Waktu : {$resultd['B']}<br>\r\n Status : <font color=#7BC409><b>{$status}</b></font>\r\n </td>\r\n <td width='2%'><a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>";
$no++;
}
echo "\r\n <tr colspan='6'>\r\n\r\n </tr>";
echo "</table>";
}
}
?>
</body>
</html>
function perkalian($k1, $k2)
{
// ini fungsi tanpa return
echo "hasil perkalian {$k1} x {$k2} = " . $k1 * $k2;
}
function nama($nama)
{
$ket = "";
if ($nama == "Dicky") {
$ket = "Kamu Pasti Sedang Praktikum {$nama}";
} else {
$ket = "Saya tidak kenal kamu {$nama}";
}
return $ket;
}
$k1 = 2;
$k2 = 5;
perkalian($k1, $k2);
echo "<br>";
echo "10 + 7 = " . penjumlahan(10, 7) . "<br>";
$nama = "Dicky";
echo nama($nama);
echo "<br>";
echo 'hasil dari 5 - 3 = ' . pengurangan();
echo "<br>";
$b1 = 15;
$b2 = 3;
echo "hasil dari {$b1} : {$b2} = " . pembagian($b1, $b2);
?>
</body>
</html>
