I need help with creating pages...

I'm not sure what it is called but I'd like something like this

<< 1 2 3 4 5 >>

at the bottom of each page.

Can someone point me to a tutorial or show me the code for a MySQL query for creating multiple pages.