[drupal-devel] Mysql problem

Gerhard Killesreiter killesreiter at physik.uni-freiburg.de
Thu May 12 06:44:40 UTC 2005

On Thu, 12 May 2005, Gordon Heydon wrote:

> db_query('UPDATE {ec_ad_team} at LEFT JOIN {ec_transaction} t ON
> at.txnid = t.txnid SET at.did = %d WHERE t.workflow = %d and at.did =
> 0', $did, 6);
> The problem is that for some reason the on my clients mysql server
> doesn't seem to do the update, can anyone give me a reason why this
> would be happening, and a possible method of resolving this.

UPDATE does not support JOINs according to the mysql manual.


More information about the drupal-devel mailing list