i want to write a PERL CGI program that can show 10 records each pages of my database.
i use DBI and mysql.
i would like to show the page numbers in every pages so that a user can click for example 2, then bring him to page2.
i want that the number of pages are automatically calculated in the program.
how to implement this?
how can i get the number of records in my database?
using this value, i can divide it by 10 so that i can get the number of pages.
any one help me?