No, only one db at a time may be updated. The "where" clauses can contain
multiple db.

-----Original Message-----
From: Sascha Braun [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31, 2002 7:04 PM
To: PHP Mailingliste
Subject: [PHP] UPDATE Query

I want to know if its possible to update two databases with one query?

Please look at this example:

UPDATE news_db, newsreferenz_db SET news_db.head = 'DFB Pokalasfasf',
news_db.text = 'alkfhaslk fl akshf lakshf lkahs lfk aslf yxvyxvyxvyxv',
newsreferenz_db.kat_id = '3' WHERE = '6' AND
newsreferenz_db.news_id = '6'

it doesn't work.

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to