Show records from record 3 and then on?!?

Databases
1

I’m trying to figure out if its possible to skip the irst 2 records and then show all after that?

I’m trying to get comments to a blog out of an table but the 2 latest is allready shown so I want to make a button to show the rest… Can this be done?

The sql that get the 2 latest comment:

SELECT * FROM ".$prefix."_clubnews WHERE comment = 1 AND ori_newsid=$newsid ORDER BY newsid ASC LIMIT 2

How to make a query to gte only the rets without the 2?

Thanks in advance :wink:

2

use LIMIT.
I quote from the mysql manual

To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615