advance to next record
I have a page that returns 1 record based on a clicked image from a previous page. We want to allow the user to move to the next record or a previous record in that table. I use mysqli to open the recordset. I tried to apply the mysqli record paging to next and previous record, but when I do, the page gives me a "Error in SQL syntax". The page is http://loyalneighbor.com/inductee.php?id=1
The statement I applied is below. Do I need to do a repeat region first?
<ul class="portfolio-pagination">
<li class="prev"><a href="<?php echo $inductee->getPrevPageLink(); ?>" class="button medium no-bg"><span class="arrow left">»</span> Previous</a></li>
<li class="next"><a href="<?php echo $inductee->getNextPageLink(); ?>" class="button medium no-bg">Next <span class="arrow">»</span></a></li>
</ul><!-- end .portfolio-pagination -->