Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given i

Java124628022 2012-03-02 02:14:33

$sql = "select count(uid) as user from user_table where uid='".$this->username."'and password='".md5($this->password,self::USERCONST)."'";
$query = $this->database->setSQL($sql);
if($row = $this->database->select_array($query)){
echo $row["user"];
有问题查询的结果只有一条记录为什么不能读呢如果user==1就证明有这个用户 1以上就重复了
他的输出结果是:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in F:\wamp\www\user\DB\MySql.php on line 27
请求助



<?php

class UserEntity{

	private $username;

	private $password;

	const USERCONST = "Huang520Yu520Hong";					//常量 用户名+常量再加密往数据库里插

	private $database;

	function __construct($u,$p){

		include("../DB/MySql.php");

		$this->database = new MySql();

		$this->username = $u;

		$this->password = $p;

	}

	function register(){

		$pmd5 = md5($this->password.self::USERCONST);



		$sql = "insert into user_table (username,password) values('".$this->username."','".$pmd5."')";

		$database->setSQL($sql);

	}

	function logout(){

		echo "注销";

	}

	function login(){

		echo "登录";

	}

	function usercheck(){																					//密码加常量

		$sql = "select count(uid) as user from user_table where uid='".$this->username."'and password='".md5($this->password,self::USERCONST)."'";

		$query = $this->database->setSQL($sql);

		if($row = $this->database->select_array($query)){

			echo $row["user"];

		}

	}

}

?>



<?php





 class MySql{

 	private $host;

 	private $username;

 	private $password;

 	private $database;





 	function __construct(){

		$this->host = "localhost";

		$this->username = "root";

		$this->password = "";

		$this->database = "bkqs";

		$this->mysqlconnection();

 	}

 	function mysqlconnection(){

		$connection = mysql_connect($this->host,$this->username,$this->password) or die ("连接数据库失败");

		mysql_select_db($this->database,$connection) or die ("打开数据库失败");

		mysql_query("set names 'GBK'");

 	}

 	function setSQL($sql){

		return mysql_query($sql);

 	}

 	function select_array($query){

 		return mysql_fetch_array($query);

 	}

 	function select_object($query){

 		return mysql_fetch_object($query);

 	}

 	function close(){

 		return mysql_close();

 	}

 }

?>