common Posted July 14, 2009 Share Posted July 14, 2009 Hi all I have a few tables in a database and each have a different number of records. Say one has 10 records, another 34records, and another 8 records. I can display this in a page,but then I have all the records at once on that page. How can I create the page with a sort of a counter that I only display 10 records at a time, so if there is 34 records in a table, that the same page is used 4 times, and the on the first display it show record 1-10 and on the next it show 11-20 and so on... Can someone please help me with this?? ??? Quote Link to comment https://forums.phpfreaks.com/topic/165926-php-mysql/ Share on other sites More sharing options...
premiso Posted July 14, 2009 Share Posted July 14, 2009 http://dev.mysql.com/doc/refman/5.0/en/select.html Look into "LIMIT" at the page above. For a tutorial on "Pagination" which is what you are looking for, take a look Here Quote Link to comment https://forums.phpfreaks.com/topic/165926-php-mysql/#findComment-875165 Share on other sites More sharing options...
phporcaffeine Posted July 14, 2009 Share Posted July 14, 2009 Google "php mysql tabbed results" or "php mysql pagination" Quote Link to comment https://forums.phpfreaks.com/topic/165926-php-mysql/#findComment-875166 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.