How can I show content of two tables

danield · #1 (**permalink**) 08-22-2007, 07:01 AM

Hello,

I don't know, why I didn't get a reply to my first quest.
Perhaps it was to complicate, so I will try it one more times, more easy.

I want to get a recordset with the following fields in it:
adr_address.id, adr_address_kind.type, adr_address.name, adr_address.surename

How can I realize this?
Sorry, this are my first steps with ZF.

SQL Dump:

CREATE TABLE `adr_address` (
`id` int(10) unsigned NOT NULL auto_increment,
`adr_address_kind_id` int(10) unsigned NOT NULL,
`name` varchar(45) default NULL,
`surename` varchar(45) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `adr_address` VALUES (1, '1', 'Muffin', 'Ben');

CREATE TABLE `adr_address_kind` (
`id` int(10) unsigned NOT NULL auto_increment,
`typ` varchar(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `adr_address_kind` VALUES (1, 'Main Address');

Controller
ContactController.php

PHP Code:


			
class ContactController extends Zend_Controller_Action 

{

    function indexAction()

    {

        $this->view->title = "list of Addresses";

        

        $contact = new Contact();

        $this->view->contacts = $contact->getContactList();        

        $this->render();

        

    }  

}

Model
Contact.php

PHP Code:


			
class Contact extends Zend_Db_Table

{

    protected $_name = 'adr_head';

    protected $_primary = 'id';

    protected $_sequence = true;

    

    public function getContactList ()

    {

        // should give back:

        // adr_address.id, adr_address_kind.type, adr_address.name, adr_address.surename

        // and I don't know, how to make it :-((

              

        return $this->fetchAll();

    }      

}

Thank you for Help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode