select * from table order by id desc limit ($page-1)*$page_size , $page_size => SELECT * FROM table ORDER BY id DESC LIMIT $page_size, ($page-1)*$page_size
应该是这样的吧: SELECT select_list FROM table_expression [LIMIT { number | ALL }] [OFFSET number]SELECT * FROM table ORDER BY id DESC LIMIT $page_size OFFSET ($page-1)*$page_size
=>
SELECT * FROM table ORDER BY id DESC LIMIT $page_size, ($page-1)*$page_size
SELECT select_list FROM table_expression [LIMIT { number | ALL }] [OFFSET number]SELECT * FROM table ORDER BY id DESC LIMIT $page_size OFFSET ($page-1)*$page_size