you just barely beat me. i solved the problem:
PHP Code:
$pagenumber=$pagenumber-1;
$start=($pagenumber*$linksperpage);
$end=$start+$linksperpage;
$links=$DB_site->query("SELECT user.username,link.* FROM link LEFT JOIN user ON (user.userid=link.userid) WHERE link.folderid='".$folderid."' LIMIT ".$start.", ".$end);
while ($link=$DB_site->fetch_array($links)) {
$link[date]=vbdate("m-d-Y",$link[dateline]);
$link[time]=vbdate("h:i A",$link[dateline]);
$link[rating]=round($link[points]/$link[voters],1);
eval("\$linkbits .= \"".gettemplate("links_listbit")."\";");
}
if you didn't notice, i screwed up my limiting variables. i needed to subtract 1 from the pagenumber, so that page 1 would start from record 0, page 2 from 20, page 3 from 40, etc.
thanks for your help, i wouldn't have noticed some things.