회원정보수정페이진데요...
이상하게스리 수정하면 정보가 나와야하잖아요.
다른부분은 다 나오는데 주소랑 나머지 주소가 안나와요...
안보여줘요. 똑 같이 해줬는데 왜 그러죠?
그칸만 빈란이예요.
다시 주소를 써야해요.
<%
Set db = Server.CreateObject("ADODB.Connection")
db.Open("dsn=bookmart; uid=sa; pwd=0000")
sql = "select * from member where id='" & session("id") & "'"
set rs = db.Execute(sql)
id = Rs("id")
pass1 = Rs("pass1")
pass2 = Rs("pass2")
email = Rs("email")
name = Rs("name")
sex = Rs("sex")
mn1 = Rs("mn1")
mn2 = Rs("mn2")
zip = Rs("zip")
zip2 = Rs("zip2")
adress = Rs("address")
adress2 = Rs("address2")
addrgubn = Rs("addrgubn")
telno = Rs("telno")
hpno = Rs("hpno")
mailyn = Rs("mailyn")
Rs.Close
Set Rs = Nothing
%>
<IMG
border=0 height=12
src="../images/user.gif" width=12> 우편번호</p> </td>
<td width="453"><p class="lee"><input
name="memb_zip" maxlength="3"
size="4" style="border:1 dashed" value="<%=zip%>"> - <input type="text" name="memb_zip2" size="4" style="border:1 dashed" value="<%=zip2%>"> <input type="button" value="주소찾기" onClick="javascript:zip_ser();" name="button" style="border:1 dashed">
</td>
</tr>
<tr>
<td width="124"><p class="lee" style="MARGIN-LEFT: 5px"
><IMG
border=0 height=12
src="../images/user.gif" width=12> 주소지</p></td>
<td width="453"><p class="lee"><input
name="memb_address" maxlength="200"
size="30" style="border:1 dashed" value="<%=address%>"></p></td>
</tr>
<tr>
<td width="124"><p class="lee" style="MARGIN-LEFT: 5px"
><IMG
border=0 height=12
src="../images/user.gif" width=12> 나머지 주소</p> </td>
<td colspan="3" height=23 width="300">
<input type="text" name="memb_address2" size="30" maxlength="70" style="border:1 dashed" value="<%=address2%>">
</td>
</tr>
<tr>
이상하게스리 수정하면 정보가 나와야하잖아요.
다른부분은 다 나오는데 주소랑 나머지 주소가 안나와요...
안보여줘요. 똑 같이 해줬는데 왜 그러죠?
그칸만 빈란이예요.
다시 주소를 써야해요.
<%
Set db = Server.CreateObject("ADODB.Connection")
db.Open("dsn=bookmart; uid=sa; pwd=0000")
sql = "select * from member where id='" & session("id") & "'"
set rs = db.Execute(sql)
id = Rs("id")
pass1 = Rs("pass1")
pass2 = Rs("pass2")
email = Rs("email")
name = Rs("name")
sex = Rs("sex")
mn1 = Rs("mn1")
mn2 = Rs("mn2")
zip = Rs("zip")
zip2 = Rs("zip2")
adress = Rs("address")
adress2 = Rs("address2")
addrgubn = Rs("addrgubn")
telno = Rs("telno")
hpno = Rs("hpno")
mailyn = Rs("mailyn")
Rs.Close
Set Rs = Nothing
%>
<IMG
border=0 height=12
src="../images/user.gif" width=12> 우편번호</p> </td>
<td width="453"><p class="lee"><input
name="memb_zip" maxlength="3"
size="4" style="border:1 dashed" value="<%=zip%>"> - <input type="text" name="memb_zip2" size="4" style="border:1 dashed" value="<%=zip2%>"> <input type="button" value="주소찾기" onClick="javascript:zip_ser();" name="button" style="border:1 dashed">
</td>
</tr>
<tr>
<td width="124"><p class="lee" style="MARGIN-LEFT: 5px"
><IMG
border=0 height=12
src="../images/user.gif" width=12> 주소지</p></td>
<td width="453"><p class="lee"><input
name="memb_address" maxlength="200"
size="30" style="border:1 dashed" value="<%=address%>"></p></td>
</tr>
<tr>
<td width="124"><p class="lee" style="MARGIN-LEFT: 5px"
><IMG
border=0 height=12
src="../images/user.gif" width=12> 나머지 주소</p> </td>
<td colspan="3" height=23 width="300">
<input type="text" name="memb_address2" size="30" maxlength="70" style="border:1 dashed" value="<%=address2%>">
</td>
</tr>
<tr>
다음검색