쪽지2 질문 드립니다 정보
쪽지2 질문 드립니다
본문
1.쪽지 클릭시 윈도우 창이 뜨는데
쪽지를 서브페이지 처럼
메인페이지에 뜨게 하려면
어느페이지를 어떻게 수정해야하나요??
2. 쪽지2 주소록을 클릭하면
select 'recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_recv a left join g4_member b on a.me_send_mb_id = b.mb_id where a.me_recv_mb_id = 'admin' group by a.me_send_mb_id union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_send a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.me_send_mb_id = 'admin' group by a.me_recv_mb_id union all select 'save_send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='send' group by a.me_recv_mb_id union all select 'save_recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_send_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='recv' group by a.me_send_mb_id
1064 : You have an error in your SQL syntax near 'union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*' at line 3
error file : /bbs/memo.php
이런 메세지가 뜹니다
어느부분이 잘못된걸까여;
쪽지를 서브페이지 처럼
메인페이지에 뜨게 하려면
어느페이지를 어떻게 수정해야하나요??
2. 쪽지2 주소록을 클릭하면
select 'recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_recv a left join g4_member b on a.me_send_mb_id = b.mb_id where a.me_recv_mb_id = 'admin' group by a.me_send_mb_id union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_send a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.me_send_mb_id = 'admin' group by a.me_recv_mb_id union all select 'save_send' as type, a.me_recv_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_recv_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='send' group by a.me_recv_mb_id union all select 'save_recv' as type, a.me_send_mb_id as mb_id, count(*) as cnt, b.mb_nick, b.mb_email, b.mb_homepage from g4_memo_save a left join g4_member b on a.me_send_mb_id = b.mb_id where a.memo_owner = 'admin' and memo_type='recv' group by a.me_send_mb_id
1064 : You have an error in your SQL syntax near 'union all select 'send' as type, a.me_recv_mb_id as mb_id, count(*' at line 3
error file : /bbs/memo.php
이런 메세지가 뜹니다
어느부분이 잘못된걸까여;
댓글 전체
http://dev.mysql.com/doc/refman/4.1/en/union.html
UNION is used to combine the result from multiple SELECT statements into a single result set. UNION is available from MySQL 4.0.0 on.
mysql 버젼이 낮아서 그렇습니다.
UNION is used to combine the result from multiple SELECT statements into a single result set. UNION is available from MySQL 4.0.0 on.
mysql 버젼이 낮아서 그렇습니다.