Database class returning false

[_tina_]

Hi,

 

Can anyone see what I'm doing wrong in the following code?  My queries are coming back false.

It connects fine, just the queries return false.

Thanks in advance.

 

<?php  

class database
{
private $connectlink;	//Database Connection Link
private $username = "root";
private $password = "root";
private $database = "test";
private $hostname = "localhost";
private $resultlink; 
private $rows;	 

public function __construct() {
$this->connectlink = mysql_connect($this->hostname,$this->username,$this->password);  
if(!($this->connectlink)) {
	throw new DatabaseConnectionException("Error Connecting to the Database".mysql_error(),"101");
}
else {
	mysql_select_db($this->database);
}
}

public function __destruct() {
@mysql_close($this->connectlink);
}

public function query($sql) {
		$this->resultlink = mysql_query($sql);  
	return $this->resultlink;
}


}

  
?>

 

$db = new database();

$sql = "insert into test ( table ) values ( '".$val."' ); ";	 
	try {
		$res = $db->query($sql);
	}
catch (Exception $ex) {
	echo "An error has occurred: " . $ex->getMessage();
}

[KrisNz]

Are you sure it's not just that query that's failing? table is a mysql keyword, try putting `table` instead. You should add some error handling to your query method also.