Hey.. Im making this forum and want to LIMIT my results to 10. If there are more than 10 results, then a link appears with a href of $PHP_SELF?start=10
(by the way... $start increments by 10 everytime)
I used this for the query...
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 ORDER BY ORDER BY PID DESC LIMIT '$start', '$start+10';");
}
When $start isn't true, 10 results are displayed, but when $start is true, all the results are displayed along with the next link that displays all the results again. For an example of this goto...
http://www.welsh-symposium.com/forum/topics.php?BID=1
and hit the next link a few times. You'll see for yourself what's happening then.
I don't know why this is happening, but I would hope that there's someone out there who does know.
Please reply if you have a possible answer to this problem.
Thanks,
Regards,
Stezz.
