에러 좀 봐주세요... 정보
에러 좀 봐주세요...첨부파일
본문
후라보노보노님의 오픈마켓형식의 포인트샵 사용했습니다.
잘 작동했는데..갑자기 장바구니에서 주문하기 누르면 아래처럼 에러가 생기네요
..에구 db가 없다는 소리인지? db에는 wr_9가 있던데.. 무슨 소리인지 모르겠네요..
좀 도와주세요....고수님들..
혹시 몰라 이부분 (장바구니) 소스도 같이 올려 볼게요..
update g4_write_B01 set wr_9 = wr_9 + where wr_id = '11'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where wr_id = '11'' at line 3
error file : /skin/board/HP-order/cart_order2.php
잘 작동했는데..갑자기 장바구니에서 주문하기 누르면 아래처럼 에러가 생기네요
..에구 db가 없다는 소리인지? db에는 wr_9가 있던데.. 무슨 소리인지 모르겠네요..
좀 도와주세요....고수님들..
혹시 몰라 이부분 (장바구니) 소스도 같이 올려 볼게요..
update g4_write_B01 set wr_9 = wr_9 + where wr_id = '11'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where wr_id = '11'' at line 3
error file : /skin/board/HP-order/cart_order2.php
댓글 전체
update g4_write_B01 set wr_9 = wr_9 + where wr_id = '11'
쿼리가 잘못되었습니다.
wr_9 = wr_9 +
에서 뒷부분 숫자가 없네요...
쿼리가 잘못되었습니다.
wr_9 = wr_9 +
에서 뒷부분 숫자가 없네요...
쿼리처리 하는 소스가 이부분 같은데 어느 소스가 잘못되었는지 좀 가르쳐 주시겠어요?..
<?
//구매수량을 쇼핑몰 판매갯수로 넘김
$sql = " update g4_write_$row2[wr_10]
set wr_9 = wr_9 + $row2[wr_21]
where wr_id = '$row2[wr_13]' ";
sql_query($sql);
//구매 포인트 차감
$pay = $row2[wr_22];
$subject = $row2[wr_subject];
insert_point("$member[mb_id]","-$pay","$subject 구매");
//장바구니에서 구매로 변경값 입력
$sql = " update g4_write_$bo_table
set wr_content = '".$_POST['wr_content']."',
wr_15 = 'order',
wr_41 = '0000',
wr_42 = 'point',
wr_23 = '".$_POST['wr_23']."',
wr_24 = '".$_POST['wr_24']."',
wr_25 = '".$_POST['wr_25']."',
wr_26 = '".$_POST['wr_26']."',
wr_27 = '".$_POST['wr_27']."'
where wr_15 = 'cart' ";
sql_query($sql);
///판매자에게 값 넘기기
$wr_num = get_next_num($write_table);
$sql = " insert into g4_write_$board[bo_10]
set wr_num = '-$row2[wr_id]',
wr_reply = '$row2[wr_reply]',
wr_is_comment = '$row2[wr_is_comment]',
wr_comment = '$row2[wr_comment]',
wr_comment_reply = '$row2[wr_comment_reply]',
ca_name = '".addslashes($row2[ca_name])."',
wr_option = '$row2[wr_option]',
wr_subject = '".addslashes($row2[wr_subject])."',
wr_content = '".$_POST['wr_content']."',
wr_link1 = '".addslashes($row2[wr_link1])."',
wr_link2 = '".addslashes($row2[wr_link2])."',
wr_link1_hit = '$row2[wr_link1_hit]',
wr_link2_hit = '$row2[wr_link2_hit]',
wr_trackback = '".addslashes($row2[wr_trackback])."',
wr_hit = '$row2[wr_hit]',
wr_good = '$row2[wr_good]',
wr_nogood = '$row2[wr_nogood]',
mb_id = '".addslashes($row2[wr_11])."',
wr_password = '$row2[wr_password]',
wr_name = '".addslashes($row2[wr_11])."',
wr_email = '".addslashes($row2[wr_email])."',
wr_homepage = '".addslashes($row2[wr_homepage])."',
wr_datetime = '$row2[wr_datetime]',
wr_last = '$row2[wr_last]',
wr_id = '$row2[wr_id]',
wr_parent = '$row2[wr_id]',
wr_1 = '".addslashes($row2[wr_1])."',
wr_2 = '".addslashes($row2[wr_2])."',
wr_3 = '".addslashes($row2[wr_3])."',
wr_4 = '".addslashes($row2[wr_4])."',
wr_5 = '".addslashes($row2[wr_5])."',
wr_6 = '".addslashes($row2[wr_6])."',
wr_7 = '".addslashes($row2[wr_7])."',
wr_8 = '".addslashes($row2[wr_8])."',
wr_9 = '".addslashes($row2[wr_9])."',
wr_10 = '".addslashes($row2[wr_10])."',
wr_11 = '".addslashes($row2[wr_11])."',
wr_12 = '".addslashes($row2[wr_12])."',
wr_13 = '".addslashes($row2[wr_13])."',
wr_14 = '".addslashes($row2[wr_14])."',
wr_15 = 'order',
wr_16 = '".addslashes($row2[wr_16])."',
wr_17 = '".addslashes($row2[wr_17])."',
wr_18 = '".addslashes($row2[wr_18])."',
wr_19 = '".addslashes($row2[wr_19])."',
wr_20 = '".addslashes($row2[wr_20])."',
wr_21 = '".addslashes($row2[wr_21])."',
wr_22 = '".addslashes($row2[wr_22])."',
wr_23 = '".$_POST['wr_23']."',
wr_24 = '".$_POST['wr_24']."',
wr_25 = '".$_POST['wr_25']."',
wr_26 = '".$_POST['wr_26']."',
wr_27 = '".$_POST['wr_27']."',
wr_28 = '".addslashes($row2[wr_28])."',
wr_29 = '".addslashes($row2[wr_29])."',
wr_30 = '".addslashes($row2[wr_30])."',
wr_31 = '".addslashes($row2[wr_31])."',
wr_32 = '".addslashes($row2[wr_32])."',
wr_33 = '".addslashes($row2[wr_33])."',
wr_34 = '".addslashes($row2[wr_34])."',
wr_35 = '".addslashes($row2[wr_35])."',
wr_36 = '".addslashes($row2[wr_36])."',
wr_37 = '".addslashes($row2[wr_37])."',
wr_38 = '".addslashes($row2[wr_38])."',
wr_39 = '".addslashes($row2[wr_39])."',
wr_40 = '".addslashes($row2[wr_40])."',
wr_41 = '0000',
wr_42 = 'point',
wr_43 = '".addslashes($row2[wr_43])."',
wr_44 = '".addslashes($row2[wr_44])."',
wr_45 = '".addslashes($row2[wr_45])."',
wr_46 = '".addslashes($row2[wr_46])."',
wr_47 = '".addslashes($row2[wr_47])."',
wr_48 = '".addslashes($row2[wr_48])."',
wr_49 = '".addslashes($row2[wr_49])."',
wr_50 = '".addslashes($row2[wr_50])."' ";
sql_query($sql);
$insert_id = mysql_insert_id();
// 부모 아이디에 UPDATE
sql_query(" update g4_write_$board[bo_10] set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$board[bo_10]', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$wr_11' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$board[bo_10]'");
?>
<?
//구매수량을 쇼핑몰 판매갯수로 넘김
$sql = " update g4_write_$row2[wr_10]
set wr_9 = wr_9 + $row2[wr_21]
where wr_id = '$row2[wr_13]' ";
sql_query($sql);
//구매 포인트 차감
$pay = $row2[wr_22];
$subject = $row2[wr_subject];
insert_point("$member[mb_id]","-$pay","$subject 구매");
//장바구니에서 구매로 변경값 입력
$sql = " update g4_write_$bo_table
set wr_content = '".$_POST['wr_content']."',
wr_15 = 'order',
wr_41 = '0000',
wr_42 = 'point',
wr_23 = '".$_POST['wr_23']."',
wr_24 = '".$_POST['wr_24']."',
wr_25 = '".$_POST['wr_25']."',
wr_26 = '".$_POST['wr_26']."',
wr_27 = '".$_POST['wr_27']."'
where wr_15 = 'cart' ";
sql_query($sql);
///판매자에게 값 넘기기
$wr_num = get_next_num($write_table);
$sql = " insert into g4_write_$board[bo_10]
set wr_num = '-$row2[wr_id]',
wr_reply = '$row2[wr_reply]',
wr_is_comment = '$row2[wr_is_comment]',
wr_comment = '$row2[wr_comment]',
wr_comment_reply = '$row2[wr_comment_reply]',
ca_name = '".addslashes($row2[ca_name])."',
wr_option = '$row2[wr_option]',
wr_subject = '".addslashes($row2[wr_subject])."',
wr_content = '".$_POST['wr_content']."',
wr_link1 = '".addslashes($row2[wr_link1])."',
wr_link2 = '".addslashes($row2[wr_link2])."',
wr_link1_hit = '$row2[wr_link1_hit]',
wr_link2_hit = '$row2[wr_link2_hit]',
wr_trackback = '".addslashes($row2[wr_trackback])."',
wr_hit = '$row2[wr_hit]',
wr_good = '$row2[wr_good]',
wr_nogood = '$row2[wr_nogood]',
mb_id = '".addslashes($row2[wr_11])."',
wr_password = '$row2[wr_password]',
wr_name = '".addslashes($row2[wr_11])."',
wr_email = '".addslashes($row2[wr_email])."',
wr_homepage = '".addslashes($row2[wr_homepage])."',
wr_datetime = '$row2[wr_datetime]',
wr_last = '$row2[wr_last]',
wr_id = '$row2[wr_id]',
wr_parent = '$row2[wr_id]',
wr_1 = '".addslashes($row2[wr_1])."',
wr_2 = '".addslashes($row2[wr_2])."',
wr_3 = '".addslashes($row2[wr_3])."',
wr_4 = '".addslashes($row2[wr_4])."',
wr_5 = '".addslashes($row2[wr_5])."',
wr_6 = '".addslashes($row2[wr_6])."',
wr_7 = '".addslashes($row2[wr_7])."',
wr_8 = '".addslashes($row2[wr_8])."',
wr_9 = '".addslashes($row2[wr_9])."',
wr_10 = '".addslashes($row2[wr_10])."',
wr_11 = '".addslashes($row2[wr_11])."',
wr_12 = '".addslashes($row2[wr_12])."',
wr_13 = '".addslashes($row2[wr_13])."',
wr_14 = '".addslashes($row2[wr_14])."',
wr_15 = 'order',
wr_16 = '".addslashes($row2[wr_16])."',
wr_17 = '".addslashes($row2[wr_17])."',
wr_18 = '".addslashes($row2[wr_18])."',
wr_19 = '".addslashes($row2[wr_19])."',
wr_20 = '".addslashes($row2[wr_20])."',
wr_21 = '".addslashes($row2[wr_21])."',
wr_22 = '".addslashes($row2[wr_22])."',
wr_23 = '".$_POST['wr_23']."',
wr_24 = '".$_POST['wr_24']."',
wr_25 = '".$_POST['wr_25']."',
wr_26 = '".$_POST['wr_26']."',
wr_27 = '".$_POST['wr_27']."',
wr_28 = '".addslashes($row2[wr_28])."',
wr_29 = '".addslashes($row2[wr_29])."',
wr_30 = '".addslashes($row2[wr_30])."',
wr_31 = '".addslashes($row2[wr_31])."',
wr_32 = '".addslashes($row2[wr_32])."',
wr_33 = '".addslashes($row2[wr_33])."',
wr_34 = '".addslashes($row2[wr_34])."',
wr_35 = '".addslashes($row2[wr_35])."',
wr_36 = '".addslashes($row2[wr_36])."',
wr_37 = '".addslashes($row2[wr_37])."',
wr_38 = '".addslashes($row2[wr_38])."',
wr_39 = '".addslashes($row2[wr_39])."',
wr_40 = '".addslashes($row2[wr_40])."',
wr_41 = '0000',
wr_42 = 'point',
wr_43 = '".addslashes($row2[wr_43])."',
wr_44 = '".addslashes($row2[wr_44])."',
wr_45 = '".addslashes($row2[wr_45])."',
wr_46 = '".addslashes($row2[wr_46])."',
wr_47 = '".addslashes($row2[wr_47])."',
wr_48 = '".addslashes($row2[wr_48])."',
wr_49 = '".addslashes($row2[wr_49])."',
wr_50 = '".addslashes($row2[wr_50])."' ";
sql_query($sql);
$insert_id = mysql_insert_id();
// 부모 아이디에 UPDATE
sql_query(" update g4_write_$board[bo_10] set wr_parent = '$wr_id' where wr_id = '$wr_id' ");
// 새글 INSERT
sql_query(" insert into $g4[board_new_table] ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$board[bo_10]', '$wr_id', '$wr_id', '$g4[time_ymdhis]', '$wr_11' ) ");
// 게시글 1 증가
sql_query("update $g4[board_table] set bo_count_write = bo_count_write + 1 where bo_table = '$board[bo_10]'");
?>
//구매수량을 쇼핑몰 판매갯수로 넘김
$sql = " update g4_write_$row2[wr_10]
set wr_9 = wr_9 + $row2[wr_21]
where wr_id = '$row2[wr_13]' ";
sql_query($sql);
이 쿼리에서 $row2[wr_21] 이값을 못가지고와서 생기는 오류입니다
$sql = " update g4_write_$row2[wr_10]
set wr_9 = wr_9 + $row2[wr_21]
where wr_id = '$row2[wr_13]' ";
sql_query($sql);
이 쿼리에서 $row2[wr_21] 이값을 못가지고와서 생기는 오류입니다