Yes, the point is that "JOIN" goes before "SET" and the third argument is for "WHERE" criteria.
lightflowmark wrote: > > Hi - take a look at 15.1.4.3. Updating Data. > > The update method takes 3 arguments - 1st is the table, 2nd is the array > of data to change, and 3rd is an SQL string with the criteria. > > Yours, > Mark > > > > mysticav wrote: >> >> I was looking the PDO update method which is explained in >> >> Zend Framework: Documentation >> Example 15.22. Updating Rows >> >> >> But I can't see the way to define a Join statement. >> >> Let's say I need to define the following query: >> >> UPDATE foo >> JOIN bar ON foo.id = bar.id >> SET active=1 >> WHERE bar.status=1 >> > > -- View this message in context: http://www.nabble.com/About-PDO-update-method-tp23609587p23616344.html Sent from the Zend Framework mailing list archive at Nabble.com.
