<?php
class MySQLQuery{
	//data members
	private $strSQL;
	private $databasename;
	private $connection;
	private $result;

	public function __construct( $strSQL, $databasename, $connection ){
		$this->strSQL = $strSQL;
		$this->connection = $connection;
		$this->databasename = $databasename;
		if(!mysql_selectdb($databasename, $connection)){
			throw new MySQLException(mysql_error(), mysql_errno());
		}
		if(!$this->result = mysql_query($strSQL, $connection)){
			throw new MySQLException(mysql_error(), mysql_errno());
		}
	}

	public function __destruct(){
		$this->close();
	}

	public function getDatabaseName(){
		return $this->databasename;
	}

	public function getNumberRows(){
		return mysql_affected_rows($this->result);
	}
	
	public function getInsertId(){
		return mysql_insert_id( $this->connection);
	}


	private function close(){
		if(isset($this->result)){
			unset($this->result);
		}
	}
}
?>