$host="localhost";
$user="root";
$pass="123456";
$db="db_test";
$link=mysql_connect($host,$user,$pass) or die ("No Connect");
mysql_select_db($db) or die ("No select");
$sql="SELECT * FROM testproject";
mysql_query("SET NAMES TIS620");
$result=mysql_db_query($sql,$link) or die ("No Query");
$num=mysql_num_rows($result);
echo $num;
<body bgcolor="#FFFFCC">
<?php
$sql = "SELECT id,username, password, role_type FROM user_member_it50_tbl WHERE username='$user_login' AND password='$pwd_login' AND role_type='$select'";