Example #1
0
                <th>참여일자</th>
              </tr>
            </thead>
            <tbody>
<?php 
$where = "";
if ($sDate != "") {
    $where .= " AND mb_regdate >= '" . $sDate . "' AND mb_regdate <= '" . $eDate . " 23:59:59'";
}
if ($search_txt != "") {
    $where .= " AND " . $search_type . " like '%" . $search_txt . "%'";
}
$buyer_count_query = "SELECT count(*) FROM " . $_gl['winner_info_table'] . " WHERE 1 " . $where . "";
list($buyer_count) = @mysqli_fetch_array(mysqli_query($my_db, $buyer_count_query));
$PAGE_CLASS = new Page($pg, $buyer_count, $page_size, $block_size);
$BLOCK_LIST = $PAGE_CLASS->blockList();
$PAGE_UNCOUNT = $PAGE_CLASS->page_uncount;
$buyer_list_query = "SELECT * FROM " . $_gl['winner_info_table'] . " WHERE mb_name <> 'admin' " . $where . " Order by idx DESC LIMIT {$PAGE_CLASS->page_start}, {$page_size}";
$res = mysqli_query($my_db, $buyer_list_query);
while ($buyer_data = @mysqli_fetch_array($res)) {
    $buyer_info[] = $buyer_data;
}
foreach ($buyer_info as $key => $val) {
    ?>
              <tr>
                <td><?php 
    echo $PAGE_UNCOUNT--;
    ?>
</td>	<!-- No. 하나씩 감소 -->
                <td><?php 
    echo $buyer_info[$key]['mb_ipaddr'];