I can't see how to update (sorry, my mistake, not select *doh* ;) ) this? In the Manual I can't find a part, where it is described, how to do this?
How should I do this: Table User: | Table Info ID | user_ID Nick | information Now let´s say classes are named like the tables, all Relationships have been entered. How can I now do an Update like this: $Info->update() doing the following: Update "Info.information" where "Info.user_ID" is the to "user.Nick" corresponding "user.ID" ? For example: User "dummy" has ID 23. Now I want to update Info.information only knowing the dummy! Sorry, I don´t understand how it should work. Best regards and thanks for the help ViShap -----Original Message----- From: Matthew Weier O'Phinney [mailto:[EMAIL PROTECTED] Sent: Montag, 22. Oktober 2007 21:50 To: [email protected] Subject: Re: [fw-general] Zend_Db_Table_Ralationships and select() -- ViShap <[EMAIL PROTECTED]> wrote (on Monday, 22 October 2007, 08:34 PM +0200): > I have the following Problem: > > How can I write this statement using $db->select() ? > > > > UPDATE `register`,`users` You can't. Zend_Db_Select only does SELECT statements, not UPDATE or DELETE. Now, that said, there are ways to make this easier. Take a look at the Zend_Db_Adapter_Abstract::insert() and update() methods, as well as the related methods in Zend_Db_Table_Abstract. <snip> > Another thing: Today I looked at Zend_Db_Table and > Zend_Db_Table_Relationships > > But there I had the same question. Can I achieve this Query using the > Zend_Db_able_Relationships – without using multiple querys? You *can* do it with Zend_Db_Table. Again, look at the update() method; the 'where' clause can refer to another table. -- Matthew Weier O'Phinney PHP Developer | [EMAIL PROTECTED] Zend - The PHP Company | http://www.zend.com/
