What about multiple tables? Can that be done?
"Mark Charette" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 news_db.id = '6' AND > newsreferenz_db.news_id = '6' > > it doesn't work. > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
