ie:
Code: Select all
array("key_1"=>"value1",
"key_2"=>"value2");Moderator: General Moderators
Code: Select all
array("key_1"=>"value1",
"key_2"=>"value2");Code: Select all
{
$and_clause .= "($propertiesїcolumn] = '$propertiesїsearch_value]') OR ";
$condition_found = true;
}Code: Select all
{
if(isset($_GETї$choice])
{
$and_clause .= "($propertiesїcolumn] = '$propertiesїsearch_value]') OR ";
$condition_found = true;
}
}Code: Select all
}
$ageL_rs_members = "0";
if (isset($_GETї'ageL'])) {
$ageL_rs_members = (get_magic_quotes_gpc()) ? $_GETї'ageL'] : addslashes($_GETї'ageL']);
}
//assume checkboxes are choice1....choice6
//put in an array that maps checkboxes to values to search for
$valuesї"choice1"] = array("column"=>"members.SAG",
"search_value"=>"sag1");
$valuesї"choice2"] = array("column"=>"members.SAG",
"search_value"=>"sagEL");
$valuesї"choice3"] = array("column"=>"members.AFTRA",
"search_value"=>"aftra1");
$valuesї"choice4"] = array("column"=>"members.AFTRA",
"search_value"=>"aftraEL");
$valuesї"choice5"] = array("column"=>"members.AEA",
"search_value"=>"aea1");
$valuesї"choice6"] = array("column"=>"members.AEA",
"search_value"=>"aeaEL");
$and_clause = "AND ";
foreach($values as $choice=>$properties)
{
if(isset($_GETї$choice]))
{
$and_clause .= "($propertiesїcolumn] = '$propertiesїsearch_value]') OR ";
$condition_found = true;
}
}
$and_clause = rtrim($and_clause," OR ");
//only add "and" clause if there is something to sort on,
//otherwise, no "and" clause = return everything.
if($condition_found)
{
$query .= $and_clause;
}
mysql_select_db($database_connHP4_php, $connHP4_php);
$query_rs_members = sprintf("SELECT members.memno, members.stage_last, members.stage_first, members.e_color, members.h_color, members.age_L, members.age_H, members.weight, members.height_ft, members.height_in, members.SAG, members.AFTRA, members.AEA, members.union_other, members.phone1, members.ph1_type, members.phone2, members.ph2_type, members.email1, members.website, members.thumb_loc, members.pic_loc, agents.agent_name, agents.agent_phone, managers.manager_name, managers.manager_phone, members.category FROM managers INNER JOIN (agents INNER JOIN members ON agents.agent_ID = members.agent_ID) ON managers.manager_ID = members.manager_ID WHERE (members.age_L >= '%s' AND members.age_H <= '%s') AND (members.weight BETWEEN '%s' and '%s') AND (members.height_ft BETWEEN '%s' and '%s') AND (members.height_in BETWEEN '%s' and '%s') AND (members.stage_last LIKE '%s%%') AND (members.category LIKE '%s')", $ageL_rs_members,$ageH_rs_members,$wL_rs_members,$wH_rs_members,$ftL_rs_members,$ftH_rs_members,$inL_rs_members,$inH_rs_members,$stageL_rs_members,$category1_rs_members);
$query_limit_rs_members = sprintf("%s LIMIT %d, %d", $query_rs_members, $startRow_rs_members, $maxRows_rs_members);
$rs_members = mysql_query($query_limit_rs_members, $connHP4_php) or die(mysql_error());
$row_rs_members = mysql_fetch_assoc($rs_members);
if (isset($_GETї'totalRows_rs_members'])) {
$totalRows_rs_members = $_GETї'totalRows_rs_members'];
} else {
$all_rs_members = mysql_query($query_rs_members);
$totalRows_rs_members = mysql_num_rows($all_rs_members);
}
$totalPages_rs_members = ceil($totalRows_rs_members/$maxRows_rs_members)-1;
?>Code: Select all
INNER JOIN (agents INNER JOIN members ON agents.agent_ID = members.agent_ID)Code: Select all
$inH_rs_members,$stageL_rs_members,$category1_rs_members);
echo;Code: Select all
if($condition_found)
{
$query .= $and_clause;
}