ch0ps Posted October 1, 2007 Share Posted October 1, 2007 DB has 110+ records, which need to organized into groups of 10 records and assigned a category. Category names can be anything (category 1, category 2, etc). Records contain general info about registered users: name, email, phone Client would like to select category name, and view only 10 records. Assistance is greatly appreciated! Quote Link to comment https://forums.phpfreaks.com/topic/71387-assign-10-records-to-category/ Share on other sites More sharing options...
fenway Posted October 1, 2007 Share Posted October 1, 2007 Assistance with what? Quote Link to comment https://forums.phpfreaks.com/topic/71387-assign-10-records-to-category/#findComment-359410 Share on other sites More sharing options...
ch0ps Posted October 1, 2007 Author Share Posted October 1, 2007 I'm unsure as to how to seperate the records in groups of ten, and dynamically assign them to a category. The end result would be a record which was automatically added to an auto incremented category based on when record was added to the db. After 10 records are added, a category would be assigned, and then the next set of 10 records would begin the next category. I need to assistance figuring how to create the categories automatcally, instead of having to manually assign each record that comes in to a category. Quote Link to comment https://forums.phpfreaks.com/topic/71387-assign-10-records-to-category/#findComment-359434 Share on other sites More sharing options...
Barand Posted October 2, 2007 Share Posted October 2, 2007 I suggest calling the categories "Page 1. Page 2, ..., Page N" If you now search these pages for "pagination" or "paging" etc you should find something that will help Quote Link to comment https://forums.phpfreaks.com/topic/71387-assign-10-records-to-category/#findComment-359718 Share on other sites More sharing options...
ch0ps Posted October 2, 2007 Author Share Posted October 2, 2007 I agree, Pagination is a simple solution to display 10 records per page. thanks However, it's possible that my client will want more flexibility down the road (no way!), I think a more robust method is preferred. In this scenario, assigning the records to a category is the main goal, giving the records a page name suffices to display the records, but offers a lot of limitations. But thanks for reminding me that the simplest solution is usually the best option. Quote Link to comment https://forums.phpfreaks.com/topic/71387-assign-10-records-to-category/#findComment-360163 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.