Member Avatar for prem2

Hi,
I have large number of records in the database.Each page displays 5 records.I am using a query "select * from tablename limit 0,5";When ever user clicks next button the limit starting value increased by 5.When user click previous button the limit value decreased by 5.Now,my problem is i want to display the page number depends upon the next and previous.

Thank you for help

  • 2 Contributors
  • 1 Reply
  • 50 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by hashinclude
Member Avatar for hashinclude

you can do that by displaying the result of dividing the larger limit value by 5

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.