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" <[EMAIL PROTECTED]> wrote in message 000c01c25142$b4d1b990$0f00a8c0@squitta">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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php