limit posts and have a next page?
| From: | Hawk | Date: | Sat, 06 Apr 2002 08:57:02 +0000 |
| Subject: | limit posts and have a next page? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-91851@lists.php.net to get a copy of this message | ||
This is just speculations, but I thought I'd as well ask now before I get to
work
Lets say I have a news page, and I only want the last ten posts to show on
it, then I ORDER BY id ASC LIMIT 10 right?
but how do I add the next page?
count rows from the database and see if its more than 10 lines, and then ?
saw something about a MAX and a MIN mysql command, but how do I use it? and
should I use it for that purpose? :)
like... ORDER BY id ASC LIMIT 10 MIN(10) MAX(20) or something?
I dont know really.. just speculations as I said :)
Håkan