以10人为一组读取Mysql数据库 - Reading Mysql database in groups of 10

Reading Mysql database in groups of 10

我需要能够一次读取Mysql数据库中10条记录的内容，这样我就可以显示前10条，然后当用户点击第2页时，我需要能够读取第二块10条记录，去掉前10条等

这是我用来读取第一个10 的

$result = mysql_query("SELECT id FROM general_thread WHERE id_topic = $id");
$num_rows = mysql_num_rows($result);

$result = mysql_query("SELECT id, user_message, user_created, user_id, user_posts, user_rank, date_created FROM general_thread WHERE id_topic = $id ORDER BY id DESC
LIMIT 10;") 
or die(mysql_error());

它不只是吗

$result = mysql_query("SELECT id, user_message, user_created, user_id, user_posts, user_rank, date_created FROM general_thread WHERE id_topic = $id ORDER BY id DESC LIMIT 10, 10;")

接下来的10年？然后

$result = mysql_query("SELECT id, user_message, user_created, user_id, user_posts, user_rank, date_created FROM general_thread WHERE id_topic = $id ORDER BY id DESC LIMIT 20, 10;")

之后的10个？

http://php.about.com/od/mysqlcommands/g/Limit_sql.htm