<< Previous n Articles
| From: | jtjohnston | Date: | Wed, 06 Feb 2002 01:59:09 +0000 |
| Subject: | << Previous n Articles | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-83664@lists.php.net to get a copy of this message | ||
I'm using this code to create a "Next n Articles >>" on my index.page
from my mysql database.
I worked most of it out myself. Then I got some help. It works. I
thought I understood my own code enough to be able to construct a "<<
Previous n Articles". I guess not. My coding skills need help.
So how do I reverse my code to construct the previous n articles from my
sql database.
if(!$offset)
{
$offset = 0;
}
$limit = 5;
$num_rows = 13;#I get this from a mysql operation
#####################################################
$new_offset = $offset + $limit;
$disp = $limit;
if ($new_offset + $limit > $num_rows)
{
$disp = $num_rows - $new_offset;
}
if ($disp > 0)
{
$nextinsert = " <font face=\"arial\" size=2><A
HREF=\"index.html?offset=".$new_offset."\">Next ".$disp." Articles
>></a></font>\n";
}
<g> Thanks if you have a second.
John