[fw-general] Zend_Db_Table_Ralationships and select()

[ViShap]

Hi all!

 

I have the following Problem:

How can I write this statement using $db->select() ?

 

UPDATE `register`,`users` 

SET `register`.`register_step` = 2,

`register`.`validmail` = NULL, 

`register`.`resendmail` = 1 

WHERE (

register.users_ID = users.ID 

AND '. $db->quoteInto('users.nick = ?', $validNick)

)

 

Can´t find a way  :/

 

 

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?

 

Hopefully

ViShap