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

Re: [PHP-DB] Unexplained MySQL Error..

://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

RE: [PHP-DB] Unexplained MySQL Error..

Chris: The MySQL documentation would make you think so... I don't think so UPDATE [LOW_PRIORITY] [IGNORE] tbl_name Note there isn't a tbl_name [, tbl_name2, ...]. It's just tbl_name... Right... that means just *one* table. Your query is updating 4 tables. Chris

Re: [PHP-DB] Unexplained MySQL Error..

://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist - Original Message - From: Boget, Chris [EMAIL PROTECTED] To: 'John Pickett' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 20, 2001 2:35 PM Subject: RE: [PHP-DB] Unexplained MySQL Error.. Chris: The MySQL documentation would

Re: [PHP-DB] Unexplained MySQL Error..

Hi Chris, I think you are onto something here.. However, this has produced another problem. Boget, Chris wrote: UPDATE WLPbib, WLPpublisher,WLPprofile,WLPbib2profile I think you can only update one table at a time... I could be wrong, though... I seperated this out into 3 update

Re: [PHP-DB] Unexplained MySQL Error..

Mike Gifford pressed the little lettered thingies in this order... Hi Chris, I think you are onto something here.. However, this has produced another problem. Boget, Chris wrote: UPDATE WLPbib, WLPpublisher,WLPprofile,WLPbib2profile I think you can only update one table at a

Re: [PHP-DB] Unexplained MySQL Error..

Thanks for your attention to this matter Christopher, Christopher Ostmo wrote: If you do not list a table in the UPDATE parameter, you cannot reference that table from anywhere else within your query. The same is true of SELECT statements - you cannot reference a table that is not listed