Thank you very much. I will call this afternoon; most likely somewhere around 2:30 pm or just after.
And just in case you can straight away see that I am on the wrong path (very likely!!), then I have developed the following two queries/routines to try to assist me:
(1)
<?php
$rsPageCount = new WA_MySQLi_RS("rsPageCount",$mysqli_navayogimarga,1);
$rsPageCount->setQuery("SELECT COUNT(ID) AS total FROM presenter_data WHERE presenter_data.ID >= 1");
$rsPageCount->execute();
?>
(2)
<?php $results_per_page = 4 ; ?>
<?php $total_pages = ceil(($rsPageCount->getColumnVal("total")) / $results_per_page); ?>
<p><strong>The Presenters appear in the ID order:<br>
<?php $previous = ""; // set my initial field determiner to 0 ?>
<?php
while(!$rsPresentersMenuListing->atEnd()) {
?>
<?php
// if it doesn't match the previous value then display the ID
if ($rsPresentersMenuListing->getColumnVal("ID") != $previous) { ?>
<?php echo $rsPresentersMenuListing->getColumnVal("ID"); ?> |
<?php
} else {
// otherwise, insert this text and non-breaking spaces
echo ' move to next ';
}
// set $previous variable to current ID value ready for next iteration
$previous = $rsPresentersMenuListing->getColumnVal("ID");
$preceding_record = $rsPresentersMenuListing->getColumnVal("ID");
?>
<?php
$rsPresentersMenuListing->moveNext();
$succeeding_record = $rsPresentersMenuListing->getColumnVal("ID");
}
$rsPresentersMenuListing->moveFirst(); //return RS to first record
?>
</strong></p>
******
And I have then gotten a bit stuck trying to display the following on the Details page. This is mainly because I can't seem to get the Page Link features to work.
Underneath is what I currently have displaying on the page. I am trying to make it possible to navigate record by record, on the Details page, while also always being possible to jump back to whatever page happens to hold that record on the Results page. Since I can't get the Page links to work, then my current work-around is to use the GET. I also can't use the values I tried to set up above of $preceding_record and $succeeding_record:
<h4 style="text-align: center"><a href="">ID = ? </a>I.e. proposed Jump to Previous Record | <a href="">ID = <?php echo $_GET['ID'] ; ?></a> Proposed Jump to Results page, whatever page shows this current record | <a href="">ID = ? </a> Proposed Jump to Next Record | etc.
Thank you,
KAB