Hi,
i put my head into the core of the sqlabstraction to find out how an
update performs for multiple tables. for an example:
$q = $pdb->createUpdateQuery();
$q->update('`domains`,`emailaddresses`')
->set('`domains.change`', '0')
->set('`emailaddresses.change`', '0');
$stmt = $q->prepare();
$stmt->execute();
@ the sqlabstraction i found the following code:
line:104
public function update( $table )
{
$table = $this->getIdentifier( $table );
$this->table = $table;
return $this;
}
this code means for me that only one table at once is possible. but why?
i think it will be quite simple to extend this section for multiple
tables update like the sql query. i am not perhaps i can create the code
and give it back to you?
--
Dominique 'NetAndroid' Schramm
- Twitter: @NetAndroid_BY
- Identi.ca: @netandroid
- Blog: http://netandroid.nl/
