최신글 추출 질문드립니다

2015.06.18 22:18:47 3075 (218.♡.♡.145)

본문

<? $query = sql_query("SELECT * FROM g5_write_".$bo_table." WHERE mb_id = '".$view['mb_id']."' AND wr_is_comment = 0 AND wr_id != ".$wr_id." ORDER BY wr_id DESC LIMIT 1"); while($rows = sql_fetch_array($query)) {?>

<?=$rows['wr_subject']?>

이렇게 게시물에 작성한 유저의 다른글들을 뽑아내고있는데요

게시물앞에 순서가 안붙더라구요...1.2.3 이런식으로..

어떻게 수정하면좋을까요?

두번째로

....글이없을땐 "게시물이 없습니다"라고 보여주고싶습니다.

초보유저라 답답하셔도 이해좀 바랍니다 ㅜㅜ

#그누보드5

답변 1

왕계란 자기소개 회원게시물 회원 질문검색 회원 답변검색 회원 댓글검색 님의 답변

2015-06-18 22:29:07 124.♡.♡.198

 
<?
$count = sql_fetch("SELECT COUNT(*) AS cnt FROM g5_write_".$bo_table." WHERE mb_id = '".$view['mb_id']."' AND wr_is_comment = 0");
if($count['cnt'] > 0) {
    $no = 1;
    $query = sql_query("SELECT * FROM g5_write_".$bo_table." WHERE mb_id = '".$view['mb_id']."' AND wr_is_comment = 0 ORDER BY wr_id DESC LIMIT 5");
    while($rows = sql_fetch_array($query)) {
?>
[<?=$no?>]제목 : <?=$rows['wr_subject']?> | 날짜 : <?=$rows['wr_datetime']?><br />
<?
        $no++; 
    }
} else {
    echo "게시물이 없습니다.";
}
?>

↳ 왕계란 자기소개 회원게시물 회원 질문검색 회원 답변검색 회원 댓글검색

2015-06-18 22:43:14124.♡.♡.198

$count = sql_fetch("SELECT COUNT(*) AS cnt FROM g5_write_".$bo_table." WHERE mb_id = '".$view['mb_id']."' AND wr_is_comment = 0");
==>
$count = sql_fetch("SELECT COUNT(*) AS cnt FROM g5_write_".$bo_table." WHERE mb_id = '".$view['mb_id']."' AND wr_is_comment = 0 AND wr_id != ".$wr_id);

$query = sql_query("SELECT * FROM g5_write_".$bo_table." WHERE mb_id = '".$view['mb_id']."' AND wr_is_comment = 0 ORDER BY wr_id DESC LIMIT 5");
==>
$query = sql_query("SELECT * FROM g5_write_".$bo_table." WHERE mb_id = '".$view['mb_id']."' AND wr_is_comment = 0 AND wr_id != ".$wr_id." ORDER BY wr_id DESC LIMIT 5");