아래는 쪽지 목록상에 출력 쿼리문입니다.
//본인에게 쪽지보낸사람 묶음
$sql = " select a.*, b.mb_id, b.mb_nick, b.mb_team, b.mb_dangimg, b.mb_dangwon
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_send_mb_id = b.mb_id)
where a.me_recv_mb_id = '$member[mb_id]'
group by a.me_send_mb_id
order by a.me_id desc limit $from_record, $rows";
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_send_mb_id = b.mb_id)
where a.me_recv_mb_id = '$member[mb_id]'
group by a.me_send_mb_id
order by a.me_id desc limit $from_record, $rows";
//본인이 쪽지보낸사람 묶음
$sql = " select a.*, b.mb_id, b.mb_nick, b.mb_team, b.mb_dangimg, b.mb_dangwon
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_recv_mb_id = b.mb_id)
where a.me_send_mb_id = '$member[mb_id]'
group by a.me_recv_mb_id
order by a.me_id desc limit $from_record, $rows";
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_recv_mb_id = b.mb_id)
where a.me_send_mb_id = '$member[mb_id]'
group by a.me_recv_mb_id
order by a.me_id desc limit $from_record, $rows";
이 두개의 쿼리문을 하나로 묶어 하나의 목록에 출력을 할려고 합니다.
어떻게 합칠수 잇을까요?
|
답변 1개 / 댓글 5개
채택된 답변
+20 포인트
$sql = $sql_1 .' union all '. $sql_2;
답변에 대한 댓글 5개
//본인에게 쪽지보낸사람 묶음
$sql_1 = " select a.*, b.mb_id, b.mb_nick, b.mb_team, b.mb_dangimg, b.mb_dangwon
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_send_mb_id = b.mb_id)
where a.me_recv_mb_id = '$member[mb_id]'
group by a.me_send_mb_id
//본인이 쪽지보낸사람 묶음
$sql_2 = " select a.*, b.mb_id, b.mb_nick, b.mb_team, b.mb_dangimg, b.mb_dangwon
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_recv_mb_id = b.mb_id)
where a.me_send_mb_id = '$member[mb_id]'
group by a.me_recv_mb_id
$sql_3 = "order by a.me_id desc limit $from_record, $rows";
$sql = $sql_1 .' union all '. $sql_2 . $sql_3;
오류가 잇네요 ;;;;;;;;;;;;;;
$sql_1 = " select a.*, b.mb_id, b.mb_nick, b.mb_team, b.mb_dangimg, b.mb_dangwon
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_send_mb_id = b.mb_id)
where a.me_recv_mb_id = '$member[mb_id]'
group by a.me_send_mb_id
//본인이 쪽지보낸사람 묶음
$sql_2 = " select a.*, b.mb_id, b.mb_nick, b.mb_team, b.mb_dangimg, b.mb_dangwon
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_recv_mb_id = b.mb_id)
where a.me_send_mb_id = '$member[mb_id]'
group by a.me_recv_mb_id
$sql_3 = "order by a.me_id desc limit $from_record, $rows";
$sql = $sql_1 .' union all '. $sql_2 . $sql_3;
오류가 잇네요 ;;;;;;;;;;;;;;
답변을 작성하려면 로그인이 필요합니다.