Search Our Catalog


Log into My Account            Looking for Digital Treasures? Click here.

 

Member Libraries

-1){ echo "".$letter." "; }else{echo " ".$letter." ";} } $count++; } } function LibraryList($query){ $color="EDEDE3"; $result = mysql_query($query) or die(mysql_error()); echo ""; while ($row = mysql_fetch_assoc($result)) { if (is_null($row['iid'])){ $image = ""; }else{ $image_query = "SELECT f.filepath FROM image i JOIN files f ON i.fid=f.fid WHERE i.image_size='thumbnail' AND nid=".$row['iid']; $image_result = mysql_query($image_query) or die(mysql_error()); $image_row = mysql_fetch_assoc($image_result); $image = "".$row["; } echo ""; if($color=="EDEDE3"){$color="FFFFFF";}else{$color="EDEDE3";} } echo "
LibraryLibrary PhotoRegion
".$row['title']." ".$image." ".$row['field_region_value']."
"; } projectsConnect(); if (array_key_exists("type",$_GET)){$type=$_GET['type'];}else{$type="0";} if (array_key_exists("letter", $_GET)){$selected_letter=$_GET['letter'];}else{$letter=0;} ?>

Libraries listed alphabetically by:
Central Region | Western Region
"; $query = "SELECT DISTINCT(field_membertype_value) FROM `content_type_memberlib` ORDER BY field_membertype_value"; $result = mysql_query($query) or die(mysql_error()); $count=0; while ($row = mysql_fetch_assoc($result)) { if($count==0){$count=1;$del="";}else{$del=" | ";} echo $del."".$row['field_membertype_value']." Member"; } echo "
"; AZMenu($selected_letter); echo "
"; ?>
You searched for '".$_POST['search']."'

"; LibraryList($query); break; case "letter": $query = "SELECT r.nid, n.title, c.field_region_value, c.field_membertype_value, a.iid FROM node_revisions r JOIN node n ON r.nid=n.nid JOIN content_type_memberlib c ON r.nid=c.nid LEFT JOIN image_attach a ON r.nid=a.nid WHERE type='memberlib' AND n.title LIKE '".$_GET['letter']."%' ORDER BY n.title"; echo "

Libraries beginning with the letter '".$_GET['letter']."'

"; LibraryList($query); break; case "membership": $query = "SELECT r.nid, n.title, c.field_region_value, c.field_membertype_value, a.iid FROM node_revisions r JOIN node n ON r.nid=n.nid JOIN content_type_memberlib c ON r.nid=c.nid LEFT JOIN image_attach a ON r.nid=a.nid WHERE type='memberlib' AND c.field_membertype_value = '".$_GET['m']."' ORDER BY n.title"; LibraryList($query); break; case "region": if($_GET['r']=='c'){$region="Central";}else{$region="Western";} $query = "SELECT r.nid, n.title, c.field_region_value, c.field_membertype_value, a.iid FROM node_revisions r JOIN node n ON r.nid=n.nid JOIN content_type_memberlib c ON r.nid=c.nid LEFT JOIN image_attach a ON r.nid=a.nid WHERE type='memberlib' AND c.field_region_value = '".$region."' ORDER BY n.title"; LibraryList($query); break; default: $query = "SELECT r.nid, n.title, c.field_region_value, c.field_membertype_value, a.iid FROM node_revisions r JOIN node n ON r.nid=n.nid JOIN content_type_memberlib c ON r.nid=c.nid LEFT JOIN image_attach a ON r.nid=a.nid WHERE type='memberlib' AND n.title LIKE 'a%' ORDER BY n.title"; LibraryList($query); break; } ?>