pagination scripts, functions, php and mysql

[gerolacho]

having no success with converting a poorly coded pagination script into functions, the pagination also has order by asc/desc of by title and rating. am not sure how to construct this pagination in functions, having problems with variables out of scope, i do not want to set global variables.the net provides many resources many which are of poor quality.I am using php and mysql to display database results.Does anyone have any good resources and scripts for pagination with sort by column_id, and possibly sort by first letter, i found a good example on this forum but it was from 2008, i am concerned abit using depreciated code.thanks