I'm not sure if anyone else as the need for a php/MySQL based bibliography, but 
the application that I am developing (which is basically a module for phpSlash) 
is coming along fairly well.  If anyone is interested in seeing the code I can 
bundle it up and send it out to them (still a long way from finished mind).  The 
draft version of it is up and running here:

I'm running into a couple problems though that I don't have the logic language 
for and I was hoping folks here could help me (as you have done in the past).

The problem is that I've set up a many to many table to ensure that I can have 
an author be listed as writing many books and a book be written by many authors.

However in listing the books as a bibliography (as the URL above), I want to be 
able to list multiple authors, and do so in a different format for the first 
author than for all subsequent ones.

I'm hoping to be able to produce output like this:
        Young, D. and N. Dixon. Helping Leaders Take Effective Action: A Program 
Evaluation. Greensboro, North Carolina: Center for Creative Leadership,

So, I think the first challenge should be to calculate which books have multiple 
authors by doing something like this (It's using phplib structures, sorry):

$q2  = "SELECT * FROM WLPbib2profile ORDER BY bibID";   
$this->db->query($q2);  // Performs above query
while ($this->db->next_record()) {
        if ($this->db->Record["bibID"] != $last_bibID) {
        echo "<br>" . $this->db->Record["bibID"] . " : " .  
        } else { // Multiple Authors
                echo ", " .  $this->db->Record["profileID"];
                $multiple_profileID .= array ($this->db->Record["bibID"] =>
                $multiple_profileID .= array($this->db->Record["bibID"] =>
                $last_bibID = $this->db->Record["bibID"];

With this I can then use the value $multiple_profileID to determine if this 
record has duplicates or not and use something like this to include both authors 
and not repeat the bibliography item:

if ($multiple_profileID[$bibID]=="yes") {
        while (list($key, $val) = each($multiple_profileID)) {
                $written_by =  $key . " : " . $val . "<br>";
                if ($this->db->Record["firstName"]) {
        $written_by .= stripslashes($this->db->Record["firstName"]) . " ";
                if($this->db->Record["lastName"]) {
        $written_by .=  stripslashes($this->db->Record["lastName"]);
} else {

                        if($this->db->Record["lastName"]) {
                                $written_by .=  
stripslashes($this->db->Record["lastName"]) . ", ";
                        if ($this->db->Record["firstName"]) {
                                $written_by .= 

But this seems really awkward (at the best of times) and (worst of all) it isn't 

I've got another related problem in that I've set up the following fields in one 

and I need to be able to order them by a combination of lastName & organization. 
  I could list the organization field simply as the lastName, but that seems 
like it would be confusing the data types...  Must be a way around this..  I 
suspect it is limited by my logic & not PHP's.

Any ideas would be appreciated.

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]

Reply via email to