User Experience Stack Exchange is a question and answer site for user experience researchers and experts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

so I am making a website and I have a mysql database that stores all the information of users.

This is the structure of my database

CREATE TABLE `profile` (
`username` VARCHAR(65) NOT NULL ,
`position` VARCHAR(65) NOT NULL ,
`champion` VARCHAR(65) NOT NULL ,
`level` INT(2) NOT NULL,
`division` VARCHAR(65) NOT NULL ,
`name` VARCHAR(65) NOT NULL,
`lolking` VARCHAR(65) NOT NULL,
 UNIQUE (`username`)

In my website I want to implement a function that people can search other users based on "division" and "posistion". So I use

SELECT * FROM profiles where `division` ="sth" and `position` = "sth"

I am currently displaying the result in a table since the database is relatively small. However, as the database has more queries, what would be an effective way to show users the result? I am thinking maybe I should build a table with tabs that each tabs show certain number of rows but I do not know how to do it.

share|improve this question
up vote 1 down vote accepted

You can just modify your table in order to provide the following:

  • paging
  • sorting
  • filtering/search
  • number of items to display

enter image description here

image source

As an addition you can introduce tree-table and use some attribute(s) as a part of the tree structure, but I really doubt you need that. So the suggestion is to enhance your current table.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.