On Wednesday 06 February 2002 09:59, jtjohnston wrote:
> 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";
> }
>
Something like:
$previous = $offset - $limit;
if ($previous < 0) { $previous = 0; }
then incorporate $previous into your previous link in a similar fashion to
the next link.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Random, n.:
As in number, predictable. As in memory access, unpredictable.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
