<? $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개 / 댓글 2개
채택된 답변
+20 포인트
2015-06-18 (목) 22:29:07
Copy
<?$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 "게시물이 없습니다.";}?>답변에 대한 댓글 2개
2015-06-18 (목) 22:43:14
답변을 작성하려면 로그인이 필요합니다.
==>
$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");