Re: Prev/Next Link problem.

here's what I do. if ( @$offset < 0 ) $offset = 0; $search_a = $offset $search_b = $offset + $limit $search_c = SELECT count(*) FROM $table if ($search_b > $search_c) $search_b = $search_c echo displaying $search_a to $search_b of $search_c if ($search_a) echo <a href='$PHP_SELF?offset=". ($offset - $LIMIT) ."'>prev </a> echo <a href='$PHP_SELF?offset=0'>home </a> if ($search_b < $search_c) echo <a href='$PHP_SELF?offset=". ($offset + $LIMIT) ."'>next </a> -- Chris Lee lee@mediawaveonline.com "Michael O'Neal" <mike@thinkmango.com> wrote in message news:B7F21B4F.6191%mike@thinkmango.com... > Hi. I've got a photo gallery that I've built, that displays 6 thumbnails at > a time, and then gives previous, next, and page links. The problem is, I > always seem to end up with 1 extra page result, and the "next" link never > goes away, even when the records end. Clicking on the "next" link just > takes you to a blank page. I've been messing with the numbers in the code, > but I can't seem to figure it out, so I thought I'd instill the knowledge of > the expert masses. Can anyone help? > > The gallery itself can be found at > http://128.242.234.179/gallery/ > > Here's the code: > > // execute SQL query and get results > $limit=6; // Rows to return > $numresults=mysql_query($sql,$connection) or die ("Couldn't execute > query."); > $numrows=mysql_num_rows($numresults); > > // next determine if offset has been passed to script, if not use 0 > if (empty($offset)) { > $offset=0; > } > > // Get Results > $result=mysql_query("SELECT ID,title,thumbnail FROM $table_name limit > $offset,$limit"); > > > // now you can display the results returned > $i=1; > while ($row = mysql_fetch_array($result)) { > > > > $ID=$row['ID']; > $thumbnail=$row['thumbnail']; > $title=$row['title']; > if (is_int($i/3)) { > > $display_block .= "<display code snipped...> > > } > > else { > > $display_block .= "<display code snipped> > > } > > $i++; > > } > > // next we need to do the links to other results > if ($offset>0) { // bypass PREV link if offset is 0 > $prevoffset=$offset-6; > > $prev_link .= "<a > href=\"$PHP_SELF?offset=$prevoffset\">PREV</a>\n"; > } > > // calculate number of pages needing links > $pages=intval($numrows/$limit); > > // $pages now contains int of pages needed unless there is a remainder from > division > if ($numrows%$limit) { > > // has remainder so add one page > $pages++; > } > > for ($i=1;$i<=$pages;$i++) { // loop thru > > $newoffset=$limit*($i-1); > $pages_link .= "<a > href=\"$PHP_SELF?offset=$newoffset\">$i</a>\n"; > } > > // check to see if last page > if (!(($offset/$limit)==$pages) && $pages!=0) { > > // not last page so give NEXT link > $newoffset=$offset+$limit; > $next_link .= "<a > href=\"$PHP_SELF?offset=$newoffset\">NEXT</a><p>\n"; > } > > > <END PHP CODE> > > If possible, please reply to mike@thinkmango.com, as I am on the digest. > > Thanks, > > > mto > > -- > > Michael O'Neal > Web Producer/ Autocrosser > ST 28 '89 Civic Si > --------------------- > M A N G O > B O U L D E R > --------------------- > http://www.thinkmango.com > e- mike@thinkmango.com > p- 303.442.1821 > f- 303.938.8507 >