argh!

[N!ck]

i also tried simplifying the query to see if that was the problem. i changed it to:

PHP Code:

$links=$DB_site->query("SELECT * FROM link WHERE folderid='".$folderid."' LIMIT $start, $end"); 


still no luck.

[Xenon]

but you are sure it's already filled correctly? ^^

try these two:

PHP Code:

$links=$DB_site->query("SELECT * FROM link WHERE folderid=".intval($folderid)." LIMIT $start, $end"); 


and if that doesnt help just test it with this

PHP Code:

$links=$DB_site->query("SELECT * FROM link"); 


[N!ck]

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.

[Xenon]

glad it works now

you're welcome