I am creating this database to learn how to do multiple things. The first thing I want to learn how to do is create multiple pages if database output is over 20 people. For example goto this page if you look to the right it says pages 1 - 4 and you can click on each on and it will show more players without having a separate page. Does this make sense? If anyone could help me I would really like to learn this meanwhile ill be reading my books looking for an answer.

Removed

What you're looking for is called pagination.
http://www.google.com/search?hl=en&s...php+pagination

Thank you so much! Sorry for my ignorance

http://yerpik.com/upload/i.php is what i have now I need to figure out how be able to click on each of the columns to make it sortable.

Originally Posted by NYChaoS

I need to figure out how be able to click on each of the columns to make it sortable.

Clicking the column name sets an "ORDER BY column" query and redisplays the page, to change the direction of the sort use a link that wsitches between ASCending order and DESCending order.