Assign 10 records to category

[ch0ps]

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!

[fenway]

Assistance with what?

[ch0ps]

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.

[Barand]

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

[ch0ps]

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.