[Lynne]

You would do something like this:

PHP Code:

    function prepare_output($id = '', $options = array()) 
    { 
$subres = $this->registry->db->query_read("SELECT STATEMENT HERE");
$result = $this->registry->db->fetch_array($subres);

        $this->block_data['mymodification'] = 'HTML OUTPUT'; 
    }