업데이트시 오류 질문입니다. 정보
업데이트시 오류 질문입니다.본문
update g4_write_telephone where no=309 set name = '유', nick = 'ㅀㅇㄹㅇ', is_group = '친구', p1 = '*** 개인정보보호를 위한 휴대폰번호 노출방지 ***', p2 = '000-0000-0000', p3 = '000-0000*0000', p4 = '000*000', p5 = '', p6 = '', addr = '집', email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', relations = '나라', birthday = '2000.8.5', age = '23', title = '테스트입니다.', content = 'ㅇㄹㄴㅇㄹㅇ', default1 = '', default2 = '', default3 = '', default4 = '', default5 = '', default6 = '', is_date = '2009-08-29 19:42:55'
1064 : 'SQL 구문에 오류가 있습니다.' 에러 같읍니다. ('where no=309 set name = '유', nick = 'ㅀㅇㄹㅇ',' 명령어 라인 1)
이런 오류가 나오는데 어디가 문제가 있어서 이렇게 나오는 거에요? 도무지 찾을수가 없습니다.
고수님들께서 좀 도와주세요...부탁드리겠습니다.
[[해당소스 입니다.]]
if ($a) {
$sql = "update g4_write_telephone where no='$row[no]'
set name = '$name',
nick = '$nick',
is_group = '$is_group',
p1 = '$p1',
p2 = '$p2',
p3 = '$p3',
p4 = '$p4',
p5 = '$p5',
p6 = '$p6',
addr = '$addr',
email = '$email',
relations = '$relations',
birthday = '$birthday',
age = '$age',
title = '$title',
content = '$content',
default1 = '$default1',
default2 = '$default2',
default3 = '$default3',
default4 = '$default4',
default5 = '$default5',
default6 = '$default6',
is_date = '".date('Y-m-d H:i:s')."'";
sql_query($sql);
echo "<script>location.replace('telephonlist_update.php');</script>";
}
?>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>title image</TD>
</TR>
<TR>
<TD><HR size="3" color="#FF3333"></TD>
</TR>
</TABLE>
<FORM method="post" action="telephonlist_update.php" name="telephonlist" enctype="multipart/form-data">
<input type="hidden" name="a" value="1">
<TABLE WIDTH="100%" BORDER="1" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>성명</td>
<td><input type="text" name="name" value="<?=$row[name]?>" size="20"></td>
<td>별명</td>
<td><input type="text" name="nick" value="<?=$row[nick]?>" size="20"></td>
<td>E-Mail</td>
<td><input type="text" name="email" value="<?=$row[email]?>" size="20"></td>
</tr>
<tr>
<td>주소</td>
<td colspan="7"><input type="text" name="addr" value="<?=$row[addr]?>" size="20"></td>
</tr>
<tr>
<td>전화번호1</td>
<td><input type="text" name="p1" value="<?=$row[p1]?>" size="20"></td>
<td>전화번호2</td>
<td><input type="text" name="p2" value="<?=$row[p2]?>" size="20"></td>
<td>전화번호3</td>
<td><input type="text" name="p3" value="<?=$row[p3]?>" size="20"></td>
<td>전화번호4</td>
<td><input type="text" name="p4" value="<?=$row[p4]?>" size="20"></td>
</tr>
<tr>
<td>관계</td>
<td><input type="text" name="relations" value="<?=$row[relations]?>" size="20"></td>
<td>생일</td>
<td><input type="text" name="birthday" value="<?=$row[birthday]?>" size="20"></td>
<td>나이</td>
<td><input type="text" name="age" value="<?=$row[age]?>" size="20"></td>
<td>메모</td>
<td><input type="text" name="title" value="<?=$row[title]?>" size="20"></td>
</tr>
<tr>
</table>
</TD>
</TR>
<TR>
<TD>
<table width="100%" border="1">
<tr>
<td>남기고 싶은 글</td>
<td><textarea name="content" value="<?=$row[content]?>" cols="136" rows="8"></textarea></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD>
<INPUT TYPE="submit" NAME="" VALUE="입력"> <INPUT TYPE="reset" NAME="" VALUE="취소"> <INPUT TYPE="button" NAME="" VALUE="목록" onClick="location.href='./telephonlist.php'">
</TD>
</TR>
</TABLE>
</FORM>
댓글 전체

$sql = "update g4_write_telephone
set
name = '$name',
nick = '$nick',
is_group = '$is_group',
p1 = '$p1',
p2 = '$p2',
p3 = '$p3',
p4 = '$p4',
p5 = '$p5',
p6 = '$p6',
addr = '$addr',
email = '$email',
relations = '$relations',
birthday = '$birthday',
age = '$age',
title = '$title',
content = '$content',
default1 = '$default1',
default2 = '$default2',
default3 = '$default3',
default4 = '$default4',
default5 = '$default5',
default6 = '$default6',
is_date = '".date('Y-m-d H:i:s')."'
where no='$row[no]'";
이렇게 해보시면 어떨까요?
알려주신대로 하니 오류는 없어졌어요...^^
정말 감사합니다.. ㅎㅎㅎ
근데요..한가지만 더 물어볼께요...
바꿀내용을 입력을 하고 입력 버튼을 누르면 수정이 안되어져 있거든요... 그건 왜 그런건지...알수가 없네요... 또 쿼리쪽이 문제가 있는걸까요? 아니면 값을 못 받아와서 그런걸까요?..T.T
$sql = "select * from g4_write_telephone where no='$no'";
$query = sql_query($sql);
$row = sql_fetch_array($query);
if ($a) {
$sql = "update g4_write_telephone
set name = '$name',
nick = '$nick',
is_group = '$is_group',
p1 = '$p1',
p2 = '$p2',
p3 = '$p3',
p4 = '$p4',
p5 = '$p5',
p6 = '$p6',
addr = '$addr',
email = '$email',
relations = '$relations',
birthday = '$birthday',
age = '$age',
title = '$title',
content = '$content',
default1 = '$default1',
default2 = '$default2',
default3 = '$default3',
default4 = '$default4',
default5 = '$default5',
default6 = '$default6',
is_date = '".date('Y-m-d H:i:s')."'
where no='$row[no]'";
sql_query($sql);
echo "<script>location.replace('telephonlist_update.php?no=$no');</script>";
}
?>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>title image</TD>
</TR>
<TR>
<TD><HR size="3" color="#FF3333"></TD>
</TR>
</TABLE>
<FORM method="post" action="telephonlist_update.php" name="telephonlist" enctype="multipart/form-data">
<input type="hidden" name="a" value="1">
<TABLE WIDTH="100%" BORDER="1" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>성명</td>
<td><input type="text" name="name" value="<?=$row[name]?>" size="20"></td>
<td>별명</td>
<td><input type="text" name="nick" value="<?=$row[nick]?>" size="20"></td>
<td>E-Mail</td>
<td><input type="text" name="email" value="<?=$row[email]?>" size="20"></td>
</tr>
<tr>
<td>주소</td>
<td colspan="7"><input type="text" name="addr" value="<?=$row[addr]?>" size="20"></td>
</tr>
<tr>
<td>전화번호1</td>
<td><input type="text" name="p1" value="<?=$row[p1]?>" size="20"></td>
<td>전화번호2</td>
<td><input type="text" name="p2" value="<?=$row[p2]?>" size="20"></td>
<td>전화번호3</td>
<td><input type="text" name="p3" value="<?=$row[p3]?>" size="20"></td>
<td>전화번호4</td>
<td><input type="text" name="p4" value="<?=$row[p4]?>" size="20"></td>
</tr>
<tr>
<td>관계</td>
<td><input type="text" name="relations" value="<?=$row[relations]?>" size="20"></td>
<td>생일</td>
<td><input type="text" name="birthday" value="<?=$row[birthday]?>" size="20"></td>
<td>나이</td>
<td><input type="text" name="age" value="<?=$row[age]?>" size="20"></td>
<td>메모</td>
<td><input type="text" name="title" value="<?=$row[title]?>" size="20"></td>
</tr>
<tr>
</table>
</TD>
</TR>
<TR>
<TD>
<table width="100%" border="1">
<tr>
<td>남기고 싶은 글</td>
<td><textarea name="content" value="<?=$row[content]?>" cols="136" rows="8"></textarea></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD>
<INPUT TYPE="submit" NAME="" VALUE="입력"> <INPUT TYPE="reset" NAME="" VALUE="취소"> <INPUT TYPE="button" NAME="" VALUE="목록" onClick="location.href='./telephonlist.php'">
</TD>
</TR>
</TABLE>
</FORM>