$pagenav - Help, i thought that this would be easy!

[trafix]

Ok i thought that adding pages to a hack would be easy ... i cant seem to work it out from existing coding could someone explaine how to add this to a hack. A tut would be great

Thanks in advance

[Dean C]

Same here - pagination is so much harder than it looks

- miSt

[colicab-d]

pagination would be handy... maybe someone could write a good tutorial and post it in the hacking hints and tips..

please lol

[N!ck]

It's pretty easy with that pagenav() function. You just feed it your result.

[Boofo]

Can you post an example or something?

[trafix]

OK, here is the piece of coding that i require pagenav on. It comes from vbtrader.php and the primary db column is itemid,

please use this as the example ...

ooops wrong piece ... see next post

[trafix]

sorry this is the right bit of code

PHP Code:

// ###################### Start Get Listings #######################
if ($action=="getlist") {
   
   eval("\$navbar .= \"".gettemplate("trader_navbar")."\";");
   
   $getinfo2 = $DB_site->query_first("SELECT * FROM traderclasssublist WHERE subid=$subid");
     $catmain=$getinfo2[parentname];
    $catmainid=$getinfo2[parentid];
    $catsub=$getinfo2[subname];
    
$getinfo3 = $DB_site->query_first("SELECT * FROM traderclassmainlist WHERE id=$catmainid");
     
$getlist = $DB_site->query("SELECT * FROM traderlisting WHERE itemsubcatid=$subid and active=1 ORDER BY datelisted DESC");
while ($list4 = mysql_fetch_array($getlist)) {
    $list4[finish]=vbdate($dateformat,$list4[dateexpire]);
    
    $newlist="";
    if ($list4[datelisted] > $bbuserinfo[lastvisit]) {
    $newlist="color=red";
    }
    
    if (($counter++ % 2) != 0) {
                $backcolor="{firstaltcolor}";
                $bgclass="alt1";
            } else {
                $backcolor = "{secondaltcolor}";
                $bgclass="alt2";
            }
        
            
eval("\$itemlist .= \"".gettemplate("trader_itemlist_bit")."\";");
}

eval("dooutput(\"".gettemplate("trader_item_list")."\");");
  
}