Exemple #1
0
?>
</div>
    
    <?php 
$order .= " AND menu_id LIKE '%,66,%' ORDER BY date_create DESC ";
if (!@$_GET['page_number']) {
    $page_number = 1;
} else {
    $page_number = $_GET['page_number'];
}
$from = $page_number * $max_results - $max_results;
$type = 6;
//loại sql select $type = 6;
$table = 'info';
$field = array('id', 'name', 'status', 'user_create', 'date_create', 'user_update', 'date_update');
$limit = array($from, $max_results);
$sql->get_sql($type, $table, $field, $order, $limit);
$qr = $sql->executable() or die($error_sql);
while ($row = mysql_fetch_array($qr)) {
    echo list_column('thongbao', $row[$field[0]], $row[$field[1]], $row[$field[2]], $row[$field[3]], $row[$field[4]], $row[$field[5]], $row[$field[6]]);
}
mysql_free_result($qr);
/*
 * Phân trang
 */
echo '<div id="phantrang">';
phantrang($table, $max_results, $page_number, $order);
echo '</div>';
?>
    
</div>
?>
</div>
    
    <?php 
$order .= ' ORDER BY date_create DESC ';
if (!@$_GET['page_number']) {
    $page_number = 1;
} else {
    $page_number = $_GET['page_number'];
}
$from = $page_number * $max_results - $max_results;
$type = 8;
//loại sql select $type = 6;
$table = $page;
$field = array('id', 'name', 'status', 'user_create', 'date_create', 'user_update', 'date_update');
$limit = array($from, $max_results);
$sql->get_sql($type, $table, $field, $order, $limit);
$qr = $sql->executable() or die($error_sql);
while ($row = mysql_fetch_array($qr)) {
    echo list_column($page, $row[$field[0]], $row[$field[1]], $row[$field[2]], $row[$field[3]], $row[$field[4]], $row[$field[5]], $row[$field[6]]);
}
mysql_free_result($qr);
/*
 * Phân trang
 */
echo '<div id="phantrang">';
phantrang($page, $max_results, $page_number, $order, 8);
echo '</div>';
?>
    
</div>