Current Signatories

The following persons have signed the letter.  This list is sorted alphabetically by family name.  You may also view the list by most recent signatories.

 

    // maximum number of items to show:
    $count = 500;

    $result = db_query_range(db_rewrite_sql("SELECT n.nid, n.title, sig.field_signatory_affiliation_value {affil},
    sig.field_signatory_firstname_value {first_name}
    FROM {node} n, {content_type_signatory} sig
    WHERE n.type = 'signatory' AND n.nid = sig.nid AND
    n.status = 1
    ORDER BY n.title ASC, sig.field_signatory_firstname_value ASC"),$node_id,0,$count);

    while ($node = db_fetch_object($result)) {
    print "

  • " . $node->first_name . " " . $node->title . ", " . $node->affil . "
  • ";
    }
    ?>

 

Events