I have coded a page system that works inside YaPP (YaBBSE Portal), but im looking for a more efficient solution. Can anybody help?
global $db_prefix, $txt, $pptxt, $color, $action, $board, $prefs, $yytitle, $boardurl, $scripturl, $startat;
$yytitle = $prefs[title]." - $pptxt[201]";
template_header();
if (!isset($startat)) {
$startat = "0";
}
if (!isset($startat3)) {
$startat3 = "0";
}
$perpage = "7"; // query results per page
$queryamount = mysql_query("SELECT * FROM {$db_prefix}linkmodule");
$linkquery = mysql_query("SELECT * FROM {$db_prefix}linkmodule LIMIT {$startat},{$perpage}"); // link info listing
$num_rows = mysql_num_rows($queryamount); // number of links in db
print <<<EOT
<table class="bordercolor" cellspacing="1" width="100%">
<tr class="catbg">
<td>Site</td>
<td>Description</td>
<td>Date Added</td>
<td>Submitted By</td>
</tr>
EOT;
while ($data=mysql_fetch_assoc($linkquery)) {
$through = $through + 1;
$thetime = timeformat($data[date]);
print <<<EOT
<tr class="windowbg2">
<td><a href="$boardurl/index.php?action=link&id=$data[id]" target="_blank">$data[name]</a></td>
<td>$data[description]</td>
<td>$thetime</td>
<td><a href="$boardurl/index.php?action=viewprofile;user=$data[addedby]">$data[addedby]</a></td>
</tr>
EOT;
}
$startat = $startat+1;
$through = $startat+$through-1;
print <<<EOT
</table><br>Showing <b>$startat</b> - <b>$through</b> of $num_rows links
EOT;
$startat = $startat-1;
if ($startat >= "$perpage") {
$startat1 = $startat - $perpage;
print <<<EOT
<br><a href="$boardurl/index.php?action=linklist&startat=$startat1">PREVIOUS PAGE</a>
EOT;
}
$check = $startat+$perpage;
if ($check < $num_rows) {
$startat = $startat + $perpage;
print <<<EOT
<br><a href="$boardurl/index.php?action=linklist&startat=$startat">NEXT PAGE</a>
EOT;
}
print "<hr><br>Pages: [<a href=$boardurl/index.php?action=linklist&startat=0>1</a>] ";
$pagenumber1 = 1;
while ($num_rows > $startat3) {
$pagenumber1 = $pagenumber1 + 1;
$pagenumber = $pagenumber+1;
$startat3 = $pagenumber*$perpage;
if ($num_rows > $startat3) {
print "[<a href=$boardurl/index.php?action=linklist&startat=$startat3>$pagenumber1</a>] ";
}
}
footer();
obExit();