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 Huruf </b></div></td>
<td><div align=”center”><b>Total</b></div></td>
</tr>

<?
while($row=mysql_fetch_array($minta))
{
echo “<tr>”;
echo “<td bgcolor=ffffff>”.$row[0].”</td>”;
echo “<td bgcolor=ffffff>”.$row[1].”</td>”;
echo “<td bgcolor=ffffff>”.$row[2].”</td>”;
echo “<td bgcolor=ffffff>”.$row[3].”</td>”;
echo “<td bgcolor=ffffff>”.$row[4].”</td>”;
echo “<td bgcolor=ffffff>”

echo “</td>”;

echo “</tr>”;
echo “<br>”;
}
}
else {
echo “<center><font size=5 >Data yang di cari  &quot; <font color=red> <u>$data_cari</u> </font> </center>”;
echo “<center><font size=5> Tidak Ditemukan </font></center>”;
}