"; $loop = 0; $where = ""; $showFilter = ""; foreach($_POST as $key => $value){ //echo $key.": ".$value."
"; $loop++; if ($loop > 1) { $where .= " or fl_fid=$value"; $showFilter .= ", $key"; } else { $where = " where fl_fid=$value"; $showFilter .= "for $key"; } unset($_POST[$key]); } //print "where clause = $where
"; // query member table $sql = "select fl_mid from wd_functionlink".$where; //print "member query = $sql
"; $query = mysql_query($sql); for ($i=0 ; $idRow= mysql_fetch_array($query) ; $i++) { if ($idRow["fl_mid"] <> "") {$tnFilter .= " m_id='". $idRow["fl_mid"] . "' or";} } $nFilter = substr($tnFilter, 0, -3); //print "Member filter = $nFilter
"; // query network table $sql2 = "select fl_nid from wd_functionlink".$where; //print "contact query = $sql2
"; $query2 = mysql_query($sql2); for ($i=0 ; $idRow2= mysql_fetch_array($query2) ; $i++) { if ($idRow2["fl_nid"] <> "") {$tcFilter .= " n_id='". $idRow2["fl_nid"] . "' or";} } $cFilter = substr($tcFilter, 0, -3); //print "Network filter = $cFilter
"; //print "Num Mem Rows = ".mysql_num_rows($query)."
"; //print "Num Con Rows = ".mysql_num_rows($query2)."
"; } ?> War Dogs Motorcycle Club - Find Contact
Contact Us Home Page
Why War Dogs
Symbolism
Is the Club Right for Me
Prospecting
Scholarship Awards
From the 2007
Fallen Hero’s Run

Scholarship Awards
From the 2008
Fallen Hero’s Run
War Dogs
Support
Our Troops
John
"BIG DOG"
Challis
WARDOGS-MC DATABASE
Contact Information
MENU

" : $end = ""; print $begin."$f_function
".$end; } if (($f-1)%4 <> 0 ) { print ""; } ?>
AVAILABLE SERVICES
" : $begin = ""; ($f%4 == 0) ? $end = "
Check desired service(s) above and click "FIND" for filtered list.
Click "FIND" with nothing checked to return to full list.

Available Contacts
"; if ($nFilter <> "wh") { $sqlSelect = "select * from wd_member ".$nFilter." order by m_name"; //print "select = $sqlSelect
"; $selectRows = mysql_query($sqlSelect); for ( $counter=0 ; ($row = mysql_fetch_array($selectRows)) ; $counter++) { ($counter%2==0)?$bg="#ededed" :$bg="white" ; $m_id = $row["m_id"]; $m_name = $row["m_name"]; $m_email = $row["m_email"]; if (strlen($m_email) == 0){ $m_email = "--"; } $m_number = $row["m_number"]; if (strlen($m_number) == 0){ $m_number = "--"; } // get functions $fSQL = "select fl_fid from wd_functionlink where fl_mid = $m_id"; $fSEL = mysql_query($fSQL) or die ("Function Select Error: ".mysql_error()); $tmpList = ""; for ($f=0 ; $fROW = mysql_fetch_array($fSEL) ; $f++) { $fl_fid = $fROW["fl_fid"]; $f2SEL = mysql_query("select f_function from wd_function where f_id = $fl_fid"); $f2RES = mysql_fetch_array($f2SEL); $this_function = $f2RES["f_function"]; $tmpList .= $this_function.", "; } $FunctionList = substr($tmpList, 0, -2); ?> "; } // get contacts print ""; if ($cFilter <> "wh") { $sqlSelect = "select * from wd_network ".$cFilter." order by n_name"; //print "select = $sqlSelect
"; $selectRows = mysql_query($sqlSelect); for ( $counter=0 ; ($row = mysql_fetch_array($selectRows)) ; $counter++) { ($counter%2==0)?$bg="#ededed" :$bg="white" ; $n_id = $row["n_id"]; $n_name = $row["n_name"]; $n_email = $row["n_email"]; if (strlen($n_email) == 0){ $n_email = "--"; } $n_number = $row["n_number"]; if (strlen($n_number) == 0){ $n_number = "--"; } // get functions $fSQL = "select fl_fid from wd_functionlink where fl_nid = $n_id"; $fSEL = mysql_query($fSQL) or die ("Function Select Error: ".mysql_error()); $tmpList = ""; for ($f=0 ; $fROW = mysql_fetch_array($fSEL) ; $f++) { $fl_fid = $fROW["fl_fid"]; $f2SEL = mysql_query("select f_function from wd_function where f_id = $fl_fid"); $f2RES = mysql_fetch_array($f2SEL); $this_function = $f2RES["f_function"]; $tmpList .= $this_function.", "; } $FunctionList = substr($tmpList, 0, -2); ?> "; } ?>
Click the Brother's or contact's name for additional information.
Click the email address to send an email directly to the Brother or contact.
Name Email Function(s)
** M E M B E R S **
NONE
** C O N T A C T S **
NONE