You can use the LIMIT clause in your MySQL query to paginate your results from the database. Ideally you would grab a query variable from the url for page and results_per_page, for example, and use that to generate the LIMIT clause. So http://www.your-site.com?page=2&results_per_page=10
would generate a LIMIT clause like so:
...LIMIT 10, 10
To get that you would use
$page = $_GET['page'];
$results = $_GET['results_per_page'];
$limit = 'LIMIT '.(($page - 1) * $results) . ', '.$results;
Hope this helps.