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 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! 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 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 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
Archived
This topic is now archived and is closed to further replies.