Help with collating database information

Hi,

I am at a stage where i have a load of information in a database that i want to put into a webpage for people to see. 

For example i have a table that has page names that people have visited but what i want to do is say collate all of the page views of say the home page for the month. But i am really not sure how i can tell codeigniter to do this as i dont want to hard code which pages to search (as pages may change name and be added/taken away).

So what i am trying to do is say like this example

Home - 200 views
About us - 150 views 
Contact us - 100 views
Etc....

Has anyone got any ideas on how to start please?

Thanks,

Doomie