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 commands. However, the WHERE statement is hanging
now:
Database error:
Invalid SQL:
UPDATE
WLPpublisher
SET
WLPpublisher.publisherID = ''
WHERE
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.
Session halted.
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
the query.
So how how do I work bibID (which isn't defined in WLPpublisher) into the
following query:
$q = "
UPDATE
WLPpublisher
SET
WLPpublisher.publisherID = '$ary[publisherID]'
WHERE
WLPbib.bibID = '$ary[bibID]' AND
WLPbib.publisherID = WLPpublisher.publisherID";
I'm going to run into a similar problem in the next query:
$q = "
UPDATE
WLPprofile
SET
WLPprofile.firstName = '$ary[firstName]',
WLPprofile.middleName = '$ary[middleName]',
WLPprofile.lastName = '$ary[lastName]'
WHERE
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
--
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]