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?? ??? 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 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" Link to comment https://forums.phpfreaks.com/topic/165926-php-mysql/#findComment-875166 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.