And where is my advantage doing this? I fire another totally useless query (to get the structure of the table) and have to use a subquery inside my code.
Doing this makes Hardcoded solutions better and faster?! Is there no way simply doing this by $info->update($fields, ‘users.nick = ‘fooBar’ AND users.nick = users_ID’) or similar (leaving the users. ?) Otherwise a joined update would be useful oO Update() ->join(‘users’, …) regards From: Bryce Lohr [mailto:[EMAIL PROTECTED] Sent: Dienstag, 23. Oktober 2007 19:39 To: ViShap Cc: [email protected] Subject: Re: [fw-general] Zend_Db_Table_Ralationships and select() 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: [email protected] Subject: Re: [fw-general] Zend_Db_Table_Ralationships and select() -- ViShap <mailto:[EMAIL PROTECTED]> <[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.
