Mysql Data code

$host = "localhost";
$user = "root";
$pass = "root";
$data = "phpcanban";

$con = mysql_connect($host, $user, $pass, $data) or die("Ket noi khong thanh cong");
mysql_query($con, "set names utf8");
$result = mysql_query($con, "select * from lop");
if(mysql_num_rows($result) > 0) {
while($row = mysql_fetch_assoc($result)) {
echo "Lop: " . $row['malop'] . " - " . $row['tenlop'] . "<br />";
}
} else {
echo "Không có dữ liệu";
}

// sinh ra id khi insert mới
$id = mysql_insert_id();

// Order By
SELECT MaSV, TenSV, NamSinh
FROM SINHVIEN
ORDER BY MaSV ASC, NamSinh DESC