Forum pages

[TerraForm]

I have recently coded my own forums, using three scripts, index.php (forum list), forum.php (thread list), thread.php (says it all).

It has BBCode, whcih works, but I want to set it so that:

• after 60 threads, pushes the old posts onto a second "page"

• after 6 replies in thread.php it creates new ones on a new "page"

teh sql query bit is LIMIT 6 and LIMIT 60, but I dont know how to code teh bit to move it into next page (the view next page is easy<a href=\"/ forums/thread.php?f=".$REQUEST["f"]."&t=".$REQUEST["t"]."&p=".$_REQUEST["p"]."\">

Would be grateful if someone could tell me how to do the coding bit

Thanks,

[jonathen]

This is what I use for a similar script (it's a weblog, but the pagination is the same principle):

//connect to your db, then:
$articles_limit = "60";
$sql = mysql_query("SELECT * FROM $table");
$totalrows = mysql_num_rows($sql);
$pagenums = ceil ($totalrows/$articles_limit);

if ($page==''){
    $page='1';
}

$start = ($page-1) * $articles_limit;


$starting_no = $start + 1;

if ($totalrows - $start < $articles_limit) {
   $end_count = $totalrows;
} elseif ($totalrows - $start >= $articles_limit) {
   $end_count = $start + $articles_limit;
}

if ($totalrows - $end_count > $articles_limit) {
   $var2 = $articles_limit;
} elseif ($totalrows - $end_count <= $articles_limit) {
   $var2 = $totalrows - $end_count;
}

$space = "&nbsp;";
$sql = mysql_query("SELECT * FROM $table ORDER BY date DESC LIMIT $start,$articles_limit");
$num=mysql_numrows($sql);

mysql_close();

// put your variables here to loop your articles grabbed from the db.

++$i;
}
if(mysql_num_rows($sql) == 0)
{
echo "There are currently no articles in this forum!";
}
if ($page>1) {
        echo "« <a href='{$_SERVER['PHP_SELF']}?page=".($page-1)."'>Prev" . $space . $articles_limit . " articles</a>" . $space . $s$
    }


for ($i=1; $i<=$pagenums; $i++) {
    if ($i!=$page) {
        echo " <a href='{$_SERVER['PHP_SELF']}?page=$i'>$i</a>";
    }
    else {
        echo " <b>$i</b>";
    }
}


if ($page<$pagenums) {
    echo "" . $space . $space . $space . $space . " <a href='{$_SERVER['PHP_SELF']}?page=".($page+1)."'>Next " . $var2 .$
}

HTH

Jonathen

[TerraForm]

Thanks ! very grateful. Shall prove extremely useful 😛