• 목록

$sql = '';

$sql .= "SELECT";

$sql .= " od_id";

$sql .= " FROM {$g5['g5_shop_order_table']}";

$sql .= " WHERE od_id > 0";

$sql .= " AND mb_id = '{$mb_id}'";

$sql .=" AND ( od_status IN('입금', '준비', '배송', '완료'))";

$sql .= " ORDER BY od_time DESC";

$result = sql_query($sql);

$total_count = sql_num_rows($result);


// 리스트용 sql

$rows = $bcount;

$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산

$from_record = ($page - 1) * $rows; // 시작 열을 구함

 

$sql = $sql . " LIMIT ".$from_record.", ".$rows." ";

$result = sql_query($sql);