Asal Mau Pasti BISA!!: 2009-03-08

ASCENDING BY NOMOR INDUK dan NAMA

Hamim T. Mahfudillah Programming 0 komentar

ORDER BY INDUK

<html>
<body background="Glamour_Collection__Amber_No_3_by_va_deam.jpg">
 

<center>DAFTAR SISWA</center> 

<?php
$conn = mysql_connect("localhost","root","");
if (!$conn) {
echo "Could not connect to db";
exit(1);
}
$db = mysql_select_db("data",$conn);

$sqlText = "select * from entrydata order by induk";
$result = mysql_query($sqlText);
echo "<table border=1 align=center >";
echo "<tr><td width=150><center>Nama Siswa</center></td>
<td width=150><center>Nomor Induk</center></td>
<td width=150><center>Kelas</center></td></tr>";

while($row=mysql_fetch_object($result))
{
echo "<tr><td>$row->nama</td><td align=center>$row->induk</td><td align=center>$row->kelas</td></tr>";
}

echo "</table>";
?>
</body>
</html>

Untuk Acending/ ORDER BY NAMA

cari script :
$sqlText = "select * from entrydata order by induk";

Lalu ganti dengan :
$sqlText = "select * from entrydata order by nama";

Selengkapnya...

Postingan Lebih Baru Postingan Lama

Asal Mau Pasti BISA!!

About Me

Buku Tamu