Results 1 to 2 of 2
May 19, 2011, 00:50 #1
- Join Date
- Dec 2005
- 0 Post(s)
- 0 Thread(s)
Show records from record 3 and then on?!?
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
Thanks in advance ;-)
May 19, 2011, 00:59 #2
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