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 > lis

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

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..

e Dreamweaver 4 http://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 Sub

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..

> 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 D

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-DB] Unexplained MySQL Error..

Hello, I'm hoping that this error is clear to someone who is familiar with MySQL errors (cause it sure doesn't make sense to me): Database error: Invalid SQL: UPDATE WLPbib, WLPpublisher,WLPprofile,WLPbib2profile SET WLPprofile.firstName = 'asdf', WLPprofile.middleName = '', WLPprofile.lastNam