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]

Reply via email to