Chris: The MySQL documentation would make you think so...
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
Note there isn't a tbl_name [, tbl_name2, ...]. It's just tbl_name...
Cheers!
My 2 ¢
John Pickett
http://www.bvstudios.com/
Co-Author: Inside Dreamweaver 4
http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist
----- Original Message -----
From: "Boget, Chris" <[EMAIL PROTECTED]>
To: "'Mike Gifford'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 2:25 PM
Subject: RE: [PHP-DB] Unexplained MySQL Error..
> > UPDATE
> > WLPbib, WLPpublisher,WLPprofile,WLPbib2profile
>
> I think you can only update one table at a time...
> I could be wrong, though...
>
> Chris
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]