I can across this awesome tutorial just the other day:
http://design.sparklette.net/teaches/how-to-add-wordpress-pagination-without-a-plugin/
which is a modified version of this one:
http://www.kriesi.at/archives/how-to-build-a-wordpress-post-pagination-without-plugin