Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("/koneksi.php");
- // membuat awal dan header tabel
- echo "<table style='border-collapse:collapse; ' border='1' bordercolor='#D18E78' width='100%'>";
- echo " <tr>
- <td style='background:#D39580; width:30px;' align='center'><b>Jurusan</b></td>
- <td style='background:#D39580;width:150px;' align='center'><b>Jumlah</b></td>
- </tr>";
- // membaca semua data bidang
- /*
- $query = "SELECT * FROM tb_alumni";
- $hasil = mysql_query($query);
- */
- $query2 = "SELECT DISTINCT jurusan FROM tb_alumni";
- $hasil = mysql_query($query2);
- while ($data = mysql_fetch_array($hasil))
- {
- // mencari data
- /*
- $query2 = "SELECT DISTINCT jurusan FROM tb_alumni";
- $hasil2 = mysql_query($query2);
- $data2 = mysql_fetch_array($hasil2);
- */
- $jurusan = $data['jurusan'];
- // menghitung jumlah
- $query2 = "SELECT count(*) as jurusan FROM tb_alumni WHERE jurusan = '$jurusan' ";
- $hasil2 = mysql_query($query2);
- $data2 = mysql_fetch_array($hasil2);
- $jumlah = $data2['jurusan'];
- echo "
- <tr>
- <td align='center'>$jurusan</td>
- <td align='center'>$jumlah</td>
- </tr>";
- }
- // membuat akhir dari tabel
- echo "</table>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement