argh!

[N!ck]

anyone see why this query shouldn't return any results? if not, could someone please explain exactly what conditions they see in the SELECT statement, so i can go through and double-check everything? thanks.

btw, it's part of an addon i'm making that i *may* release, so i'll be sure to give credit.

PHP Code:

...
  $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]/$links[voters],1);
    eval("\$linkbits .= \"".gettemplate("links_listbit")."\";");
  }
...