You can use SELECT fields FROM table WHERE condition LIMIT 15, -1 and it
will select all from 15...
Andy
William Stokes wrote:
Hello
I have a news page which is getting quite long now and I would like to split
the news to two pages. Now I have one SQL query for all the rows and I think
I could use LIMIT to limit the results but how to limit the results for
example to 15 rows for page one and from 16 to the last on second page?
Number of rows increase daily.
One page one there's headline and short summary and the second page should
be "archive" with only the headline so all remaining rows can be printed to
one page.
Something like: "SELECT * FROM `x_news` LIMIT 0 , 15" but how to do the
archive page SELECT * FROM `x_news` LIMIT 16 , xx?
Thanks
-Will
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
