[SOLVED] How do you limit results?

[kjtocool]

Let's say I have a query like this:

 

<?php $query = "SELECT user_ID, comment FROM Article_Comments WHERE article_ID = $article_ID ORDER BY comment_ID"; ?>

 

How do I modify that query so that it:

 

A) Returns only the first 10 results.

B) Returns only results 11 through 20.

[kjtocool]

I believe this is the answer, if anyone can verify I'd appreciate it:

 

A)

<?php $query = "SELECT user_ID, comment FROM Article_Comments WHERE article_ID = $article_ID ORDER BY comment_ID LIMIT 0,9"; ?>

 

B)

<?php $query = "SELECT user_ID, comment FROM Article_Comments WHERE article_ID = $article_ID ORDER BY comment_ID LIMIT 10,9"; ?>

[kopytko]

Almost.

 

A)

limit 0, 10

 

B)

limit 10,10

[kjtocool]

So the second number starts at 1 and not 0?  Thanks for the help.