[SOLVED] problems with database class

[Stickybomb]

ok for some reason i am getting warings saying that

 

Warning: supplied argument is not a valid MySQL result resource

 

when ever i try to run my scripts.

 

for all my functions.

 

this is my class

<?php
////////////////////////////////////////////////////////////////////////////////////////
// Class: Db
// Purpose: Connect to a database, MySQL version
///////////////////////////////////////////////////////////////////////////////////////
require_once 'core.php';

class Db extends Core {

var $theQuery;
var $link;

//*** Function: DbConnector, Purpose: Connect to the database ***
function Db(){

	// Load settings from parent class
	$settings 	= Core::getSettings();

	require_once('mysql.php');

	// Get the main settings from the array we just loaded
	$host 		= $settings['dbhost'];
	$db 		= $settings['dbname'];
	$user 		= $settings['dbusername'];
	$pass 		= $settings['dbpassword'];

	// Connect to the database
	$this->link = mysql_connect($host, $user, $pass);
	mysql_select_db($db);

}

//*** Function: query, Purpose: Execute a database query ***
function query($query) {
	$this->theQuery = $query;
	return mysql_query($query, $this->link) or die(mysql_error());
}	

//*** Function: getQuery, Purpose: Returns the last database query, for debugging ***
function getQuery() {
	return $this->theQuery;
}

//*** Function: getNumRows, Purpose: Return row count, MySQL version ***
function getNumRows($result){
	return mysql_num_rows($result);
}

//*** Function: fetchArray, Purpose: Get array of query results ***
function fetchArray($result) {
	return mysql_fetch_array($result);
}

//*** Function: close, Purpose: Close the connection ***
function close() {
	mysql_close($this->link);
}

}
?>

 

Bascially I got this class directly from a tutorial that I am following so can some please help me figure out what is happening.

 

I am running it in a login class. I query the database to check for the user and if the rows is greater than 0 i validate otherwise i return to the login page.

[Mirkules]

This is probably a result of a bad query or maybe even bad connection. What does the query look like?

 

Try doing echo mysql_error() right after the connection and after the query to see if you get any more detail.