1) {
$page = $_GET['page'];
} else {
$page = 1;
}
$_sql = "Select c.comment, m.member_name, c.input_date from comment AS c
LEFT JOIN biblio AS b ON b.biblio_id = c.biblio_id
LEFT JOIN member AS m ON m.member_id = c.member_id
WHERE b.biblio_id =".$_detail_id.
" ORDER BY c.last_update DESC";
$commlist = $dbs->query($_sql);
if ($commlist) {
$_all_recs = $commlist->num_rows;
}
if ($_all_recs >0) {
$_page = ($page -1) * $_recs_each_page;
$_sql .= " Limit " . $_page. ", " . $_recs_each_page;
$commlist = $dbs->query($_sql);
$_list_comment .= '';
while ($_data = $commlist->fetch_assoc()) {
$_list_comment .= '';
}
$_list_comment .= '';
}
if (ISSET($_SESSION['mid'])) {
// Comment form
$_forms = '';
return $_list_comment.$_forms;
} else {
return $_list_comment;
}
}