잘

고수님 봐주세요~

· 2012-06-18 (월) 15:00:01 · 3494 · 1
제가 이벤트 페이지를 만드는데 처음에는 아이디하나만 나오게하는게 막혀서 찾아보니 group by로하면
한아이디만 나온다는걸 알게됐는데
두번째 문제가 응모횟수를 뽑는건 어떻게 해야하는거죠?
그냥 cnt하면 전체 응모횟수가 나오고
위에서 user_id=$user_id해봤자 user_id를 못받으니 소용없는거구..
어떻하면 응모횟수를 뽑을수있을가요?
고수님들 도와주세요

<table border="0" cellspacing="1" cellpadding="0" width="1300" bgcolor="#383838">
<tr height="30">
<td align="center" style="width:35px; background:#EFEFEF;">번호</td>
<td align="center" style="width:80px; background:#EFEFEF;">아이디</td>
<td align="center"style="width:55px; background:#EFEFEF;">이름</td>
<td align="center" style="width:90px; background:#EFEFEF;">연락처</td>
<td align="center" style="width:80px; background:#EFEFEF;">응모횟수</td>
<td align="center" style="width:40px; background:#EFEFEF;">삭제</td>
</tr>
<?
$Qry = "SELECT count(*) as cnt FROM 응모테이블 teb JOIN 회원테이블 tc ON teb.user_id = tc.id WHERE teb.del_flag = 'N' AND teb.user_id !=''";
$DB->query($Qry);
$DB->next_record();
$total_count = $DB->FieldByName["CNT"];
$DB->free_result();
$total_page_cnt = (ceil($total_count / $page_size) <= 0) ? 1 : ceil($total_count / $page_size);
if ($page > $total_page_cnt) {
$page = $total_page_cnt;
}
$Qry = "
SELECT
teb.seq AS seq, teb.user_id AS user_id,
teb.subject AS subject ,
teb.contents AS contents ,
tc.name AS name, tc.resident AS resident,
tc.addr2 AS addr2, tc.phone AS phone,
tc.hphone AS hphone
FROM
응모테이블 teb JOIN 회원테이블 tc
ON
teb.user_id = tc.id
WHERE
teb.delYN = 'N' AND teb.event_seq = 66 AND teb.user_id!=''
group by teb.user_id
order by teb.seq desc";

$DB->query($Qry);
$i = 0;
while ($DB->next_record()) {
$desccnt = $total_count - $i - ($page_size * ($page -1));
?>
<tr height=30>
<td align="center" bgcolor="#FFFFFF"></td>
<td align="center" bgcolor="#FFFFFF"></td>
<td align="center" bgcolor="#FFFFFF"></td>
<td align="center" bgcolor="#FFFFFF"></td>
<td align="center" bgcolor="#FFFFFF">???????번 </td>
<td align="center" bgcolor="#FFFFFF">삭제</td>
</tr>
<?$i++;}?>
</table>

댓글 1개

$Qry = "SELECT a.user_id, count(b.id) as cnt, b.id FROM member as a left join board as b on a.user_id = b.id WHERE a.del_flag = 'N' 이러케 하면 나올꺼 같은데요....
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
12-06-21 조회 3,982
12-06-21 조회 3,511
12-06-20 조회 3,682
12-06-20 조회 4,259
12-06-20 조회 3,341
12-06-20 조회 4,675
12-06-20 조회 3,335
12-06-20 조회 3,274
12-06-20 조회 4,087
12-06-20 조회 4,314
12-06-18 조회 4,833
12-06-18 조회 3,495
12-06-18 조회 3,622
12-06-18 조회 3,410
12-06-18 조회 4,157
12-06-18 조회 4,818
12-06-17 조회 4,044
12-06-17 조회 3,954
12-06-17 조회 3,590
12-06-16 조회 3,373
12-06-15 조회 3,196
12-06-15 조회 3,915
12-06-15 조회 4,666
12-06-15 조회 4,399
12-06-14 조회 4,030
12-06-14 조회 4,049
12-06-14 조회 3,130
12-06-14 조회 3,534
12-06-14 조회 4,842
12-06-14 조회 3,344
12-06-14 조회 3,190
12-06-13 조회 7,415
12-06-13 조회 3,673
12-06-12 조회 5,632
12-06-11 조회 3,493
12-06-11 조회 3,525
12-06-11 조회 3,509
12-06-11 조회 3,419
12-06-11 조회 3,994
12-06-11 조회 3,293
12-06-08 조회 3,361
12-06-08 조회 4,858
12-06-08 조회 3,177
12-06-08 조회 4,949
12-06-08 조회 3,962
12-06-08 조회 3,500
12-06-08 조회 3,462
12-06-08 조회 4,478
12-06-08 조회 3,092
12-06-08 조회 3,760
12-06-07 조회 4,048
12-06-07 조회 3,951
12-06-06 조회 3,366
12-06-06 조회 3,435
12-06-06 조회 3,737
12-06-06 조회 6,406
12-06-06 조회 5,986
12-06-06 조회 6,736
12-06-05 조회 5,850
12-06-05 조회 3,254
12-06-05 조회 3,331
12-06-05 조회 3,336
12-06-05 조회 1.2만
12-06-05 조회 4,991
12-06-05 조회 5,512
12-06-05 조회 5,272
12-06-05 조회 5,634
12-06-05 조회 3,557
12-06-05 조회 3,513
12-06-05 조회 7,387
12-06-04 조회 3,350
12-06-04 조회 4,201
12-06-04 조회 3,922
12-06-04 조회 3,967
12-06-03 조회 3,820
12-06-02 조회 3,223
12-06-02 조회 3,950
12-06-01 조회 3,364
12-06-01 조회 4,102
12-06-01 조회 3,680
12-06-01 조회 3,328
12-06-01 조회 4,832
12-06-01 조회 3,695
12-06-01 조회 3,303
12-05-31 조회 4,984
12-05-31 조회 3,806
12-05-31 조회 3,740
12-05-31 조회 3,724
12-05-31 조회 3,538
12-05-30 조회 3,186
12-05-30 조회 3,228
12-05-30 조회 4,049
12-05-30 조회 3,301
12-05-29 조회 4,500
12-05-29 조회 3,821
12-05-28 조회 3,211
12-05-28 조회 6,660
12-05-28 조회 3,282
12-05-27 조회 4,630
12-05-27 조회 3,891