![]() |
||||||||||||||||||||||||||||||||
ตรวจสอบสถานะการลงทะเบียน |
||||||||||||||||||||||||||||||||
if($_GET["txtKeyword"] != "") {
include 'connect.php';
mysql_connect($dbhost,$dbuser,$dbpass) or die("เชื่อมต่อ MySQL ไม่ได้");
mysql_query("set NAMES tis620");
mysql_select_db($dbname);
// Search By Reg. ID and ID Card
$strSQL = "SELECT * FROM tbfrontiersc_reg WHERE (id_reg LIKE '%".$_GET["txtKeyword"]."%' or name LIKE '%".$_GET["txtKeyword"]."%' or lastname LIKE '%".$_GET["txtKeyword"]."%' or idcard LIKE '%".$_GET["txtKeyword"]."%' or email LIKE '%".$_GET["txtKeyword"]."%')";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
//$strSQL .=" order by id ASC";
//$objQuery = mysql_query($strSQL);
while($objResult = mysql_fetch_array($objQuery)) {
?>
[ Print This Page ]
[ Close Windows ] ";
mysql_close();
} // end while
?>
|