Re: [fw-general] Zend_Db_Table_Ralationships and select()

[Bryce Lohr]

It appears you're trying to do this: $info->update($fields, "user_id = (SELECT id FROM users WHERE nick = ?)" => $userNick); As long as your nicks are unique, this will work. Note that this will produce an error on MS SQL due to a PHP bug. Regards, Bryce Lohr ViShap wrote: 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: fw-general@lists.zend.com 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.