입금통보용 페이지 구축시 관리자에게 통보메일보내기. 정보
입금통보용 페이지 구축시 관리자에게 통보메일보내기.본문
여러가지 방법을 해보앗으나 잘 안돼네요. 아래 소스좀 확인해주시고 수정소스좀 부탁드리겠습니다.
고수님들의 조언 부탁드립니다.
고수님들의 조언 부탁드립니다.
<?
include_once "_common.php";
if ($_POST[w]) $w = $_POST[w];
if ($_POST[bc_id]) $bc_id = $_POST[bc_id];
$bc_inbank_use = $_POST[bc_inbank_use];
$bc_inbank_name = $_POST[bc_inbank_name];
$bc_date_s = $_POST[bc_date_s];
$bc_money = ereg_replace(',','',$_POST[bc_money]);
$bc_money_only = $bc_money;
if ($w == '') {
$sql = " INSERT member_banktocash
SET bc_inbank_use = '$bc_inbank_use',
bc_inbank_name = '$bc_inbank_name',
bc_date_s = '$bc_date_s',
bc_money = '$bc_money',
bc_money_only = '$bc_money_only',
bc_status = '입금통보',
mb_id = '$member[mb_id]',
mb_name = '$member[mb_name]' ";
sql_query($sql);
} else if ($w == 'c') {
sql_query(" DELETE FROM member_banktocash WHERE bc_id = '$bc_id' ");
}
goto_url("./banktocash.php");
?>
( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '172559' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )
1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
error file : /15sir/bbs/board.php