Start Sorting At?

kooks

Hello,

I am trying to perfect my news script. When you go to news archives, it shows the first, second and third record - - limit 3 - - that is good, but I would like it to start with the 4th record since the first 3 are displayed elsewhere . . .

Please help

hand

SELECT * FROM table LIMIT 3,3; # Retrieve rows 4-6
http://www.mysql.com/doc/en/SELECT.html

kooks

Thank you,

That is what I have been trying - - but still I get and error:

Warning: Supplied argument is not a valid MySQL result resource in d:\htdocs\ua\newsarchives.inc.php on line 91

Could you tell me what I am doing wrong here?

$result = mysql_query("select * from ua ORDER BY storyid DESC limit $offset,$limit,-1");

hand

mysql> SELECT FROM table LIMIT 5,10; # Retrieve rows 6-15
mysql> SELECT FROM table LIMIT 95,-1; # Retrieve rows 96-last.
mysql> SELECT * FROM table LIMIT 5; # Retrieve first 5 rows

What does your third parameter ("-1") mean ? Limit only needs two parameters!