blink359 Posted December 17, 2010 Share Posted December 17, 2010 Hi there im not quite sure how to do something and was wondering if anyone can help me, I am going to create a large database with lots of fields and these are going to be displayed on a page i want to limit it to 20 per page and be able to sort them aswell by ID (default) and then a-z or z-a, i dont know how to do this and i also need to know how to create the next previous and last and first links im guessing theres a count++ involved ? im not quite sure but anyway if someone can help it will be great. Thanks, Blink359 Quote Link to comment https://forums.phpfreaks.com/topic/221959-listing-lots-of-data-from-a-mysql-database/ Share on other sites More sharing options...
Thauwa Posted December 17, 2010 Share Posted December 17, 2010 You need pagination. Try this: http://php.about.com/od/phpwithmysql/ss/php_pagination.htm Hope it helps! Quote Link to comment https://forums.phpfreaks.com/topic/221959-listing-lots-of-data-from-a-mysql-database/#findComment-1148555 Share on other sites More sharing options...
blink359 Posted December 17, 2010 Author Share Posted December 17, 2010 Thanks very much Quote Link to comment https://forums.phpfreaks.com/topic/221959-listing-lots-of-data-from-a-mysql-database/#findComment-1148557 Share on other sites More sharing options...
Thauwa Posted December 17, 2010 Share Posted December 17, 2010 Quote Link to comment https://forums.phpfreaks.com/topic/221959-listing-lots-of-data-from-a-mysql-database/#findComment-1148560 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.