조건검색으로 리스트 페이지 나오게 하는것좀 도와주실분~~ 정보
조건검색으로 리스트 페이지 나오게 하는것좀 도와주실분~~본문
//SELECT COUNT(wr_id) FROM g4_write_bo7_1 WHERE wr_1 = '010-1-1';
if($act == "search") {
$tot = mysql_result(sql_query("SELECT COUNT(wr_id) FROM g4_write_bo7_1 WHERE wr_1 = '".$wr_1."' "), 0, 0);
echo $tot;
if($tot > 0) echo "<script type='text/javascript'>parent.document.location.href='/bbs/board.php?bo_table=".$bo_table."&wr_1=".$wr_1."';</script>";
else echo "<script type='text/javascript'>alert('검색된 내역이 없습니다.');</script>";
exit;
}
?>
<style type="text/css">
<!--
.field {padding:0 10px; border-bottom:1px solid #E7E7E7; }
-->
</style>
<table width="745" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="745" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="397" align="left" valign="top"><img src="/new_image/img/title/title9_1.jpg" width="397" height="31" /></td>
<td align="right" valign="middle"><span style="padding-right:10px"><img src="/new_image/img/sub/home.jpg" align="absmiddle" /> HOME <font class="lo01"> > 수속사항 및 나의 성적체크 </font></span></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="/new_image/img/sub/title_line.jpg" width="745" height="25" /></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td align="center">
<form name='fwrite' method='post' style="margin:0;" >
<table width="745" cellpadding="0" cellspacing="0" border="0">
<input type='hidden' name='bo_table' value='bo7_1'>
<input type='hidden' name='act' value='search'>
<input type='hidden' name='wr_1'>
<tr>
<td><img src="/new_image/img/page/page9_1_top.jpg"></td>
</tr>
<tr>
<td background="/new_image/img/page/4_2mid.jpg" style="background-repeat:y-repeat;">
<table width="745" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="Center">
<table width="615" cellpadding="0" cellspacing="0" border="0">
<tr><td height="1" bgcolor="#B0B6B6" style="padding:7px;"></td></tr>
<tr>
<td width="545" height="50" align="center" style="padding:7 0 7 10;">
<select name='wr_1_1' class='ed' itemname='휴대전화' >
<option value='010' <?=($wr_1_1 == "010")?"selected":"";?>>010</option>
<option value='011' <?=($wr_1_1 == "011")?"selected":"";?>>011</option>
<option value='016' <?=($wr_1_1 == "016")?"selected":"";?>>016</option>
<option value='017' <?=($wr_1_1 == "017")?"selected":"";?>>017</option>
<option value='018' <?=($wr_1_1 == "018")?"selected":"";?>>018</option>
<option value='019' <?=($wr_1_1 == "019")?"selected":"";?>>019</option>
</select>
-
<input name='wr_1_2' class=ed value='<?=$wr_1_2?>' type='text' size='4' maxlength='4' itemname='휴대전화 두번째자리' required />
-
<input name='wr_1_3' class=ed value='<?=$wr_1_3?>' type='text' size='4' maxlength='4' itemname='휴대전화 세번째자리' required />
</td>
</tr>
<tr><td height="1" bgcolor="#B0B6B6" style="padding:7px;"></td></tr>
<tr>
<td style="padding:7 0 7 0;" align="center"><input type="image" img border="0" src="/new_image/img/page/4_2but01.jpg"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td background="/new_image/img/page/4_2bot.jpg" width="745" height="66" style="background-repeat:no-repeat;"></td>
</tr>
</table>
<script>
document.fwrite.wr_1.value=document.fwrite.wr_1_1.value+"-"+document.fwrite.wr_1_2.value+"-"+document.fwrite.wr_1_3.value;
</script>
</form>
>>
//SELECT COUNT(wr_id) FROM g4_write_bo7_1 WHERE wr_1 = '010-1-1';
이렇게 하면 카운트가 1나오는데 도통 왜 카운트가 0이 나오는지 모르겠네요
자바스크립트에서 전화번호 벨류 3개를 wr_1 벨류 값에 넣어서 실행되어저야 하는데 말이죠 ..
if($act == "search") {
$tot = mysql_result(sql_query("SELECT COUNT(wr_id) FROM g4_write_bo7_1 WHERE wr_1 = '".$wr_1."' "), 0, 0);
echo $tot;
if($tot > 0) echo "<script type='text/javascript'>parent.document.location.href='/bbs/board.php?bo_table=".$bo_table."&wr_1=".$wr_1."';</script>";
else echo "<script type='text/javascript'>alert('검색된 내역이 없습니다.');</script>";
exit;
}
?>
<style type="text/css">
<!--
.field {padding:0 10px; border-bottom:1px solid #E7E7E7; }
-->
</style>
<table width="745" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="745" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="397" align="left" valign="top"><img src="/new_image/img/title/title9_1.jpg" width="397" height="31" /></td>
<td align="right" valign="middle"><span style="padding-right:10px"><img src="/new_image/img/sub/home.jpg" align="absmiddle" /> HOME <font class="lo01"> > 수속사항 및 나의 성적체크 </font></span></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="/new_image/img/sub/title_line.jpg" width="745" height="25" /></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td align="center">
<form name='fwrite' method='post' style="margin:0;" >
<table width="745" cellpadding="0" cellspacing="0" border="0">
<input type='hidden' name='bo_table' value='bo7_1'>
<input type='hidden' name='act' value='search'>
<input type='hidden' name='wr_1'>
<tr>
<td><img src="/new_image/img/page/page9_1_top.jpg"></td>
</tr>
<tr>
<td background="/new_image/img/page/4_2mid.jpg" style="background-repeat:y-repeat;">
<table width="745" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="Center">
<table width="615" cellpadding="0" cellspacing="0" border="0">
<tr><td height="1" bgcolor="#B0B6B6" style="padding:7px;"></td></tr>
<tr>
<td width="545" height="50" align="center" style="padding:7 0 7 10;">
<select name='wr_1_1' class='ed' itemname='휴대전화' >
<option value='010' <?=($wr_1_1 == "010")?"selected":"";?>>010</option>
<option value='011' <?=($wr_1_1 == "011")?"selected":"";?>>011</option>
<option value='016' <?=($wr_1_1 == "016")?"selected":"";?>>016</option>
<option value='017' <?=($wr_1_1 == "017")?"selected":"";?>>017</option>
<option value='018' <?=($wr_1_1 == "018")?"selected":"";?>>018</option>
<option value='019' <?=($wr_1_1 == "019")?"selected":"";?>>019</option>
</select>
-
<input name='wr_1_2' class=ed value='<?=$wr_1_2?>' type='text' size='4' maxlength='4' itemname='휴대전화 두번째자리' required />
-
<input name='wr_1_3' class=ed value='<?=$wr_1_3?>' type='text' size='4' maxlength='4' itemname='휴대전화 세번째자리' required />
</td>
</tr>
<tr><td height="1" bgcolor="#B0B6B6" style="padding:7px;"></td></tr>
<tr>
<td style="padding:7 0 7 0;" align="center"><input type="image" img border="0" src="/new_image/img/page/4_2but01.jpg"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td background="/new_image/img/page/4_2bot.jpg" width="745" height="66" style="background-repeat:no-repeat;"></td>
</tr>
</table>
<script>
document.fwrite.wr_1.value=document.fwrite.wr_1_1.value+"-"+document.fwrite.wr_1_2.value+"-"+document.fwrite.wr_1_3.value;
</script>
</form>
>>
//SELECT COUNT(wr_id) FROM g4_write_bo7_1 WHERE wr_1 = '010-1-1';
이렇게 하면 카운트가 1나오는데 도통 왜 카운트가 0이 나오는지 모르겠네요
자바스크립트에서 전화번호 벨류 3개를 wr_1 벨류 값에 넣어서 실행되어저야 하는데 말이죠 ..
댓글 전체
의미를 모르겠고.. 누가 소스를 이렇게 다 적어놀까요..
매너가 안되있음...ㅋㅋㅋㅋㅋㅋ
알려주고 싶다가도 그냥 푱~~ 하고 살아짐!!!
매너가 안되있음...ㅋㅋㅋㅋㅋㅋ
알려주고 싶다가도 그냥 푱~~ 하고 살아짐!!!
음..$wr_1 에 공백이 있는건가?
trim($wr_1) 해서 해보세요.
trim($wr_1) 해서 해보세요.