My DB classes for mysql manipulation ver 1.0

class db{
var $hname;
var $dbname;
var $username;
var $pwd;
var $connection;

function __construct($hname,$dbname,$username,$pwd){
$this->connect($hname,$dbname,$username,$pwd);
}

function connect($hname,$dbname,$username,$pwd){
$this->hname = $hname;
$this->dbname = $dbname;
$this->username = $username;
$this->pwd = $pwd;

if(!($this->connection = mysql_connect($hname, $username, $pwd)))
die("Could not connect to database");
if(!mysql_select_db($dbname,$this->connection))
$this->showerror();

}

function close(){
mysql_close($this->connection);
}

function showerror(){
die("Error ".mysql_errno()." : ".mysql_error());
}

function get_connection(){
return $this->connection;
}

}

class query extends db{
var $query;
var $row;
var $result;

function __construct($query,$function,$connection){
$this->set_query($query);
$this->query($query,$function,$connection);

}

function query($query,$function,$connection){
$this->connection = $connection;
if(!($this->result = mysql_query($query,$this->connection)))
$this->showerror();

switch($function){
case 'IUD':
break;
case 'S':
$this->row = mysql_fetch_array($this->result);
break;
}

}

function set_query($query){
$this->query = $query;
}

function get_row(){
return $this->row;
}


}