Next & Prev Links from a MySQl DB

[Anon]

I used the code found on this site to do a next & prev link on items stored in a MySQL DB everything works fine except that the first record dose not show heres the code

$limit=15; // rows to return
$numresults=mysql_query("select *" .
"from catelog where catelog.manufacture='$manufacture'");
$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 *" .
"from catelog where catelog.manufacture='$manufacture' ".
"ORDER BY price DESC limit $offset,$limit");

ie if there wee 15 records only 14 would print to screen can anybody help

TIA
Richie TM

[Anon]

Maybe it's just me but I don't see the code that loops to display the records. It's kinda important since this is what your problem seems to be.

Offhand guess is that you started counting at 1 and didn't use a <= in a for loop.

btw: Read the notes posted to the two articles. You'll find that using COUNT(*) in the sql instead of a num_rows() call will save you a lot of memory overhead.

[Anon]

Sorry I thought I copied the whole thing

<? // calculate number of pages needing links
$pages=intval($numrows/$limit);

// next we need to do the links to other results
if (($pages!=0 and $pages!=1) or ($pages==1 and ($numrows%$limit)))

// If data <= 1 page skip all
{
if ($offset!=0) // bypass PREV link if offset is 0 {
$prevoffset=$offset-$limit;

?>
<?
print "<a href=\"$PHP_SELF?offset=$prevoffset&category=$category\"><FONTSIZE=1 COLOR=\"#000000\" FACE=\"Arial\"><< PREV</FONT></a> &nbsp; \n";

}

?>
<?
// $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 and make links
{
$newoffset=$limit*($i-1);
If ($offset!=$newoffset) //Make a link only for other pages
{
print "<a href=\"$PHP_SELF?offset=$newoffset&category=$category\"><FONT SIZE=1 COLOR=\"#000000\" FACE=\"Arial\">$i</FONT></a> &nbsp; \n";
} else {
print "<FONT SIZE=1 COLOR=\"#CCC000\" FACE=\"Arial\">$i</FONT> &nbsp; \n";
}
}
?>
<?
// check to see if NEXT link is needed
if ($pages!=1 or (($pages==1 and ($numrows%$limit))))
{
if (($offset+$limit)<$numrows) // if last page skip NEXT link
{$newoffset=$offset+$limit;
?>
<?
print "<a href=\"$PHP_SELF?offset=$newoffset&category=$category\"><FONT SIZE=1 COLOR=\"#000000\" FACE=\"Arial\">NEXT >></FONT></a>\n";
}
}
}
?>

TIA Richie TM