Try this, 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 to > 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 > Manisha > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php