어제 질문드렸는데..
급해서 다시 질문합니다. 죄송..

셀렉트박스에서
대분류 - 중분류 - 소분류를 선택하면 submit이 돼 버리요.
셀렉트박스를 선택할때마다 쿼리를날려 결과값이 출력되다보니 시간이 걸리는
문제점이 발생합니다.

셀렉트 박스에서 조건 선택후 submit 버튼을 클릭할때만
결과가 출력되게 하려면 어떻게 하나요?

소스는 다음과 같습니다.


<script language="javascript">
<!--
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();
}
//-->
</script>



<table border="0" cellpadding="5" cellspacing="1" width="100%" bgcolor="#CCCCCC">
 <form name="searchForm" method="post">
 <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>