-- 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/
