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 commands. However, the WHERE statement is hanging
WLPpublisher.publisherID = ''
WLPbib.bibID = '32' AND
WLPbib.publisherID = WLPpublisher.publisherID
MySQL Error: 1109 (Unknown table 'WLPbib' in where clause)
Please contact the webmaster and report the exact error message.
I can understand that MySQL is getting a bit upset because I am referring to
fields like WLPbib.bibID when the table hasn't been specifically referenced in
So how how do I work bibID (which isn't defined in WLPpublisher) into the
$q = "
WLPpublisher.publisherID = '$ary[publisherID]'
WLPbib.bibID = '$ary[bibID]' AND
WLPbib.publisherID = WLPpublisher.publisherID";
I'm going to run into a similar problem in the next query:
$q = "
WLPprofile.firstName = '$ary[firstName]',
WLPprofile.middleName = '$ary[middleName]',
WLPprofile.lastName = '$ary[lastName]'
bibID = '$ary[bibID]' AND
WLPbib2profile.bibID = WLPbib.bibID AND
WLPbib2profile.profileID = WLPbib.profileID";
so any sugestions to get over this next hurdle would be great.
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
It is a miracle that curiosity survives formal education. - A Einstein
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]