callochurcege
New Member
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\[code\]CREATE TABLE `profile` (`userID` INT(25) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`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`));\[/code\]In my website I want to implement a function that people can search other users based on "division" and "posistion". So I use \[code\]SELECT * FROM profiles where `division` ="sth" and `position` = "sth"\[/code\]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. Any help is appreciated! Thanks!