대분류 - 중분류 - 소분류 이렇게 3개의 셀렉트 박스가 있는데요.
각각의 셀렉트박스는 쿼리를날려서 선택할수 있게끔 하였습니다.
문제는 대분류를 선택하면 확인버튼을 안눌러도 쿼리를 날려 그조건에
맞는 결과가 출력이 돼버립니다. ( 이거 때문에 느려집니다.)
3개의 셀렉트 박스를 조건 선택후 확인버튼을 눌러야 결과가 출력되게 하려면
어떻게 하나요?
소스는 다음가 같습니다.
<스크립트>
function cate1Select() {
document.searchForm.cate2.options[0].selected = true;
document.searchForm.cate3.options[0].selected = true;
document.searchForm.submit();
}
function cate2Select() {
document.searchForm.cate3.options[0].selected = true;
document.searchForm.submit();
}
function cate3Select() {
document.searchForm.submit();
}
[form name="searchForm" method="get"]
[input type="hidden" name="excel" value=""]
[tr]
[td bgcolor="#FAFAFA"]
[select name="cate1" onChange="cate1Select();"]
[option value=""]대분류[/option]
[?
$sql = "SELECT cate1, cate1_name FROM ($cate_table) category GROUP BY cate1 ORDER BY cate1 ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
if($row[0] == $cate1)
echo "[option value='$row[0]' selected]$row[1][/option]";
else
echo "[option value='$row[0]']$row[1][/option]";
}
?]
[/select]
[select name="cate2" onChange="cate2Select();"]
[option value=""]중분류[/option]
[?
$sql = "SELECT cate2, cate2_name FROM ($cate_table) category WHERE cate1 = $cate1 GROUP BY cate2 ORDER BY cate2 ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
if($row[0] == $cate2)
echo "[option value='$row[0]' selected]$row[1][/option]";
else
echo "[option value='$row[0]']$row[1][/option]";
}
?]
[/select]
[select name="cate3" onChange="cate3Select();"]
[option value=""]소분류[/option]
[?
$sql = "SELECT cate3, cate3_name FROM ($cate_table) category WHERE cate1 = '$cate1' AND cate2='$cate2' GROUP BY cate3 ORDER BY cate3 ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
if($row[0] == $cate3)
echo "[option value='$row[0]' selected]$row[1][/option]";
else
echo "[option value='$row[0]']$row[1][/option]";
}
?]
[/select]
[/td]
[/tr]
[tr]
[td bgcolor="#FAFAFA"]
[select name="yy" style="width:50;"]
[option value="" selected]년[/option]
[?
for($i=$yy_start;$i[=$yy_last;$i++) {
if($i == $yy)
echo " [option value='$i' selected]{$i}[/option]";
else
echo " [option value='$i']{$i}[/option]";
}
?]
[/select]
[select name="mm" style="width:50;"]
[option value="" selected]월[/option]
[?
for($i=1;$i[=12;$i++) {
$i = sprintf("%02d",$i);
if($i == $mm)
echo " [option value='$i' selected]{$i}[/option]";
else
echo " [option value='$i']{$i}[/option]";
}
?]
[/select]
[select name="dd" style="width:50;"]
[option value=""]일[/option]
[?
for($i = 1; $i [= 31; $i++) {
$i = sprintf("%02d",$i);
if($i == $dd)
echo "[option value='$i' selected]$i[/option]";
else
echo "[option value='$i']$i[/option]";
}
?]
[/select]
[select name="job"]
[option value=""]직업[/option]
[?
foreach($jobs as $item =] $val) {
if($item == $job)
echo "[option value='$item' selected]$val[/option]";
else
echo "[option value='$item']$val[/option]";
}
?]
[/select]
[select name="area"]
[option value=""]지역[/option]
[?
$sql = "SELECT area FROM members GROUP BY area ORDER BY area DESC";
$result = mysql_query($sql);
$n = 0;
while($row = mysql_fetch_array($result)) {
if(!$row['area']) $row['area'] = "기타";
$arr_area[$row['area']] = $row['area'];
$n++;
}
foreach($arr_area as $item =] $value) {
if("$item" == "$area")
echo "[option value='$item' selected]$value[/option]";
else
echo "[option value='$item']$value[/option]";
}
?]
[/select]
[select name="age"]
[option value=""]연령[/option]
[?
foreach($age_list as $item =] $val) {
if("$item" == "$age")
echo "[option value='$item' selected]$val[/option]\n";
else
echo "[option value='$item']$val[/option]\n";
}
?]
[/select]
[/td]
[/tr]
[tr]
[td bgcolor="#FAFAFA"]
[select name="key"]
[option value="m_id" [?=$key_sel['m_id']?]]아이디[/option]
[option value="m_name" [?=$key_sel['m_name']?]]이름[/option]
[/select]
[input type="text" name="keyword" size="15" value="[?=$keyword?]"]
[input type="submit" value=" 검색 " class="htc"]
[input type="button" value=" 전체 " onclick="javascript:location.href('[?=$PHP_SELF?]?pm=[?=$pm?]')" class="htc"]
[input type="button" value="엑셀저장" class="htc" onclick="window.location.href('excel_list_cate.php?yy=[?=$yy?]&cate1=[?=$cate1?]&cate2=[?=$cate2?]&cate3=[?=$cate3?]&yy=[?=$yy?]&mm=[?=$mm?]&dd=[?=$dd?]&job=[?=$job?]&area=[?=$area?]&age=[?=$age?]&key=[?=$key?]&keyword=[?=$keyword?]');"]
[/td]
[/tr]
[/form]
|