Hello Dobromir,
Dobromir Velev wrote:
> Did you try to use something like this.
> mysql_query("SELECT DISTINCT
> WLPbib.bibID,
The only item that I want to have distinct is the first one. However, I think
that Matthew's response (to your response) is working now.
> The other thing that may help is to rearange the order of the tables in the
> FROM clause. Please check if some of the joins return more than one result -
> if you have more than one address for a publisher the query will return one
> row for every address.
Actually, I'd like to have more than one record (WLPprofile rather than WLPaddress in
this case) per bibliography item (WLPbib)
You see a book can have many authors, but I'm not sure how to build the tables
so that I can link to multiple authors.. Any sugestions? Right now there is
one profileID listed. I don't know how to organize the data so that
WLPbib.profileID can equal WLPprofile.profileID=3, WLPprofile.profileID=7, &
WLPprofile.profileID=10232.
Would Matthew's suggestion work in places where there are multiple profiles
(authors) referred to within the bib table?
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]