Forum Question...

Anon

Hey everyone!

Im making a forum for my site. Basically, the first thing the user see's, is a list of all the available boards. When they click on a board that they wish to view, all the topics for that board are displayed. If there are more than 10 topics on that board, a link appears saying "Next >>" the href to that link has this on the end &start=10 <-- this is saying "start from the 10th topic".

That works... but how do I get it so that if there are 30, 40 or even 50 topics on the board to work correctly. Because at this rate, if there are more than 10 topics after they've hit the "Next >>" link once, then if they hit it again, they'll be directed back to the same page over, and over again.

Basically, I need to increment the value of $start by 10 everytime the "Next >>" link get's hit. I also have have "<< Previous" link that's displayed if they've hit the "Next >>" already. I'll need the value of $start for the "<< Previous" link to be decremented by 10 everytime too.

If anyone out there knows what I'm talking about and know how to solve my problem, please help me! 🙂

Thanks for reading!!

Stezzy

Anon

post some code man.

sounds like you might be working with myslq but the quick fix could be:

if ($next){
$current = $current+10;
}
if ($previous){
$current = $current-10;
}

you could also check out
http://www.zend.com/codex.php?id=590&single=1

-best

Anon

$start = $start + 10;
$prev = $start - 10;

if($start) {

echo "<tr><td align=\"right\" colspan=6><a href=\"/forum/topics.php?BID=$BID&start=$prev\"><< Previous</a> | <a href=\"/forum/topics.php?BID=$BID&start=$start\">Next >></a></td></tr>";

} else {

echo "<tr><td align=\"right\" colspan=6><a href=\"/forum/topics.php?BID=$BID&start=10\">Next >></a></td></tr>";

}

That's what I have. When $start = 10, $prev is = 10 too eventhough Iv'e set $prev = $start - 10;

I don't know why it's doing it 🙁

Stezzy

Anon

if($start) {
if ($next)
{
$current = $current+10;
print '<a href="/forum/topics.php?BID=$BID&start=$current&prev=">Previous</a> |
<a href="/forum/topics.php?BID=$BID&start=$current&next=">Next</a>';
}
if ($prev)
{
$current = $current-10;
print '<a href="/forum/topics.php?BID=$BID&start=$current&prev=">Previous</a> |
<a href="/forum/topics.php?BID=$BID&start=$current&next=">Next</a>';
}
}
else {
print '<a href="/forum/topics.php?BID=$BID&start='. $current+10 .'&next=">Next</a>';
// the '. means break out of the string and parse php code
// then resume the string here: .'&next">Next</a>';
}

let me know how it goes for you.
-nm

Anon

Hey! Thanx for that bit of code, but unfortunetly, it doesn't work... I'll paste a URL for you (you'll need a user/pass to view the page and they are messer/messy)

http://www.welsh-symposium.com/forum/topics.php?BID=2&start='.%20+10%20.'&next=

It's a MySQL error... here's my query for you to see...

if(!$start) {

$result = mysql_query("SELECT PID, MID, subject, timestamp, views, islocked FROM forum WHERE BID = '$BID' AND Parent = 0 ORDER BY PID DESC LIMIT 10;");

} else {

$result = mysql_query("SELECT PID, MID, subject, timestamp, views, islocked FROM forum WHERE BID = '$BID' AND Parent = 0 AND PID >= '$start' ORDER BY ORDER BY PID DESC LIMIT 10;");

}

Let me know if you know where Iv'e gone wrong... thanx!

Leo!

Anon

that helps. (i had goofed in my code before)

i would just do something like the following:

<?
if($start)
{
$current = $start;
echo "\n<A href=\"$PHP_SELF?BID=$BID&start=". $current-10 ."\">Previous</A> | <A href=\"$PHP_SELF?BID=$BID&start=". $current+10 ."\">Next</A>";

$sql = "SELECT PID,MID,subject,timestamp,views,islocked FROM forum WHERE BID='$BID' AND Parent='0' AND PID>='$start' ORDER BY PID DESC LIMIT 10";
// where is the Parent colum coming from? it wasn't in the select.
$result = mysql_query("$sql");
or die ("\n\nError in our query: <TT>$sql</TT>". mysql_error() ."");

}
else
{
$start == "0";
$current = $start;
echo "\n<A href=\"$PHP_SELF?BID=$BID&start=". $current+10 ."\">Next</A>";

$sql = "SELECT PID,MID,subject,timestamp,views,islocked FROM forum WHERE BID='$BID' AND PID='$start' ORDER BY PID DESC LIMIT 10";
$result = mysql_query("$sql");
or die ("\n\nError in our query: <TT>$sql</TT>". mysql_error() ."");

}

i cleaned up you sql a little bit but my server is down so i can't test it.