include "login.php";
include "conn.inc";
if ($_SESSION["userId"]){
$tcFilter = "where";
$tnFilter = "where";
//if ($_GET["find"]) {
if ($_POST) {
//print "POSTING
";
$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
|
|
 |
 |
|
|
|
 |
WARDOGS-MC DATABASE Contact Information MENU
|
Available Contacts
|
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) |
include "conn.inc";
// get members
print " ** M E M B E R S ** | ";
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);
?>
|
|
|
}
} else {
print " NONE | ";
}
// get contacts
print " ** C O N T A C T S ** | ";
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);
?>
|
|
|
}
} else {
print " NONE | ";
}
?>
|
|
 |
 |
|
|
 |
 |
|
 |
 |
}?>