Help retrieving results from MySQL

[Anon]

I have a simple message board using PHP and MySQL.

What I would like to do is query the database for messages with a PostID less than a certain number but only use the first 20 results.

e.g. results with a PostID less than 10000 but only return the 20 results with PostID closest to 10000 (9999, 9998, 99997, and so on).

The problem is that I delete some posts so specifying a range < 10000 & > 9980 would not necessarily return 20 results.

Any ideas would be a great help,

Ben Graves.

[Anon]

Use the LIMIT clause - check it out in the MySQL documentation.

Diego

[Anon]

Thanks mate the limit clause works just as I need.