while($row = mysql_fetch_object($result))
{
   $results[] = $row->var      ..of Array("iets" => $row->var)
}

$recordSet = $database->query($query);
$recordSet->fetch();
$var = $recordSet->get('var');

$recordSet = $database->queryAndFetch($query);
$var = $recordSet->get('var');

$query = "SELECT blahdiblah FROM meuk WHERE iets";
$result = mysql_query($query);
$row = mysql_fetch_object($result)
$var = $row->var

<?

class Database
{
    var $connection;
    var $result;
    
    function Database($host, $username, $password)
    {
        $this->connection = mysql_connect($host, $username, $password) or die(mysql_error($this->connection));
    }
    
    function selectDatabase($name)
    {
        mysql_select_db($name, $this->connection);
    }
    
    function query($query)
    {
        $this->result = mysql_query($query, $this->connection) or die(mysql_error($this->connection));
    }
    
    function fetch()
    {
        return mysql_fetch_assoc($this->result);
    }
}

?>

class Database
{
    function Database()
    {
        $db_servername  = 'server';
        $db_username        = 'user';
        $db_password        = 'pass';
        
        if (!$db = @mysql_connect("$db_servername","$db_username","$db_password"))
        {
            echo 'Could not connect to MySQL Server';
            die;
        }
    }
    
    function connect($database)
    {
        mysql_select_db($database);
    }
}

$db = new Database()

$db->connect('blaat')