I had help with using the follwing script to generate a navigational menu to display so many fields per page..
Can use the same script altered to generate a next and previous navagational menu?
//Functions
function ScrollInit($field, $limit)
{
global $SCROLL_START;
global $SCROLL_LIMIT;
global $SCROLL_FIELD;
global $SCROLL_PAGE;
$SCROLL_FIELD = $field;
$SCROLL_LIMIT = $limit;
global ${$SCROLL_FIELD};
$SCROLL_PAGE = ${$SCROLL_FIELD};
$SCROLL_START = ($SCROLL_PAGE - 1) * $SCROLL_LIMIT;
}
function ScrollSummary($text, $fields, $count)
{
global $SCROLL_START;
global $SCROLL_LIMIT;
global $SCROLL_FIELD;
global $SCROLL_PAGE;
global $HTTP_SERVER_VARS;
global $SYSTEM_WORDS;
$html = $HTTP_SERVER_VARS['REQUEST_URI'];
$js = "scroll.%s.selectedIndex=%d;scroll.submit();return false";
$first = ($count ? $SCROLL_START + 1 : 0);
$last = min($SCROLL_START + $SCROLL_LIMIT, $count);
$num_pages = (int)(($count - 1) / $SCROLL_LIMIT) + 1;
for ($i = 1; $i <= $num_pages; $i++)
$pages[$i] = $i;
echo "<!-- Page Scrolling -->\n\n";
FormBegin ("$html", "scroll");
foreach ($fields as $field)
{
FormHidden($field);
}
echo "<table width=\"600\" cellspacing=\"0\" cellpaddding=\"0\" border=\"0\">\n";
echo "<tr valign=\"middle\">\n";
echo "<td class=\"smfont\" align=\"left\">";
echo sprintf($text, $first, $last, $count);
echo "</td>\n";
echo "<td class=\"smfont\" align=\"right\">\n";
if ($pages > 1)
{
if ($SCROLL_PAGE > 1)
{
echo "<a href=\"$html\" onclick=\"";
echo sprintf($js, $SCROLL_FIELD, $SCROLL_PAGE - 2);
echo "\"><<</a> \n";
}
else
{
echo " \n";
}
echo $SYSTEM_WORDS['Page']." ";
FormSelect ($SCROLL_FIELD, $pages, 0, 0, "this.form.submit();");
echo " ".$SYSTEM_WORDS['of']." $num_pages\n";
if ($SCROLL_PAGE < $num_pages)
{
echo " <a href=\"$html\" onclick=\"";
echo sprintf($js, $SCROLL_FIELD, $SCROLL_PAGE);
echo "\">>></a>\n";
}
else
{
echo " \n";
}
}
else
{
echo " \n";
}
echo "</td>\n";
echo "</tr>\n";
FormEnd();
echo "</table>\n\n";
}
// Script to select from database
ScrollInit('page', 10);
$count = DBSelectValue("SELECT COUNT(*) FROM ".USER_HISTORY_TABLE." ".
"WHERE login_id = '".addslashes($login_id)."'");
$entries = DBSelectAllArrays("SELECT " .
"rec_no, action, value, reason, ".
"DATE_FORMAT(change_date, '%b %e/%y %H:%i') AS change_date ".
"FROM ".USER_HISTORY_TABLE." ".
"WHERE login_id = '".addslashes($login_id)."' ".
"ORDER BY rec_no DESC ".
"LIMIT $SCROLL_START, $SCROLL_LIMIT");
// Navigational Menu Displayed
ScrollSummary($LOGS_MSG, array('login_id'), $count);
The guy who created this is not available and I am having a problem altering it..
To generate <a href=""><< previous log</a> <span class="hltgray">—</span> <a href="">next log >></a>
Can some help or point me in the right direction if I can use the same funtions..
Thanks Tim