Re: UPDATE Query
| From: | Brian J. Celenza | Date: | Sun, 01 Sep 2002 12:29:04 +0000 |
| Subject: | Re: UPDATE Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114828@lists.php.net to get a copy of this message | ||
Try changing your query to this: 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')
Adding the ()'s around the WHERE definition is essential in an update query,
although I have no clue why.
"Sascha Braun" <saschabraun@gmx.de> wrote in message
news:000c01c25142$b4d1b990$0f00a8c0@squitta...
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.