eliyana’s blog

SELECT
Select dari 3 bual tabel :
SELECT E.nrp, E.nama, C.nama,C.sks,B.huruf
FROM mhs AS E, mk AS C, nilai AS B
WHERE E.nrp=B.nrp AND B.kode=C.kode
AND E.nrp LIKE ‘%$data_cari%’;
relasi ke PHP:
$minta=mysql_query($sql);
$jum=mysql_num_rows($minta);
echo $jum;
$minta=mysql_query($sql);
if ($jum >0 )
{
?>
<font size=”+2″><strong>Hasil Pencarian</strong></font><br>
<? echo “<font size=3> Data yang dicari &nbsp;&nbsp;<u><strong>”.$data_cari. “</strong></u></font>”?>
<table width=”100%” border=”1″ >
<tr bgcolor=”#bfdoea”>
<td><div align=”center”><b>NRP</b></div></td>
<td><div align=”center”><b>Nama</b></div></td>
<td><div align=”center”><b>Nama MK </b></div></td>
<td><div align=”center”><b>S K S </b></div></td>
<td><div align=”center”><b>Nilai [...]