최신글 추출 질문드립니다
본문
<? $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 이런식으로..
어떻게 수정하면좋을까요?
두번째로
....글이없을땐 "게시물이 없습니다"라고 보여주고싶습니다.
초보유저라 답답하셔도 이해좀 바랍니다 ㅜㅜ
답변 1
<?
$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 "게시물이 없습니다.";
}
?>
$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");
어제에이어 오늘도 감사합니다!!좋은밤되세요 계란님~
