Hello,
I'm trying to get around a database problem that I'm having in which multiple
authors are producing (almost - the authors are listed as different) duplicate
returns within a bibliography.
What I've done is query the database and produce a list of duplicates using
something like this (this is written using phplib):
while ($this->db->next_record()) {
if ($this->db->Record["bibID"] != $last_bibID) {
echo "<br>" . $this->db->Record["bibID"] . " : " .
$this->db->Record["profileID"];
} else { // Multiple Authors
echo ", " . $this->db->Record["profileID"];
$multiple_profileID = array ($this->db->Record["bibID"] =>
$this->db->Record["profileID"]);
}
$last_bibID = $this->db->Record["bibID"];
}
Now this produces results like this:
1 : 1
2 : 2, 3
3 : 4
4 : 5
5 : 6, 7
where the first number corresponds to the book and the second the author(s).
If there are multiple authors I would like the values for bibID and profileID to
be inserted into an array. This is outlined above.
I'd like to use something like this to produce the values of all of the authors
(profileID) associated with the respective book.
if ($multiple_profileID[$this->db->Record["bibID"]]) {
while (list($key, $val) = each($multiple_profileID)) {
echo $key . " : " . $val . "<br>";
}
}
I would hope that the result would be
2 : 2
2 : 3
5 : 6
5 : 7
I can then pull out the author's name using the profileID.
If someone has an idea of a better way to do this I'd be happy to hear it.
I can send code & tables for those who might be interested.
Thanks!
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 General 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]
