쪽지2 질문 드립니다 > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

쪽지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
이런 메세지가 뜹니다

어느부분이 잘못된걸까여;
  • 복사

댓글 전체

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 버젼이 낮아서 그렇습니다.
© SIRSOFT
현재 페이지 제일 처음으로