To retrieve all rows from a certain offset upto the end of the result set,
you can use -1 for the second parameter:
mysql> SELECT * FROM table LIMIT 95,-1; # Retrieve rows 96-last.
"Manisha" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am having forum table. First 10 records are treated as Current postings
> and rest are treated as Archive.
> I know how to take first 10
> select * from forum order by postdate desc LIMIT 10
> But I do not know how to take postings excluding above 10. I do not want
> make use of loop rather I want to do this in one single query as I need to
> pass this to some further include files.
> Thanks in advance
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php