You can accomplish this by using a limit in the sql statement.
Code:
if(!isset($_GET['page']))
{
$page = 1;
}
else
{
$page = $_GET['page'];
}
$query = 'select * from products limit '.$page.',10';
then for the next/previous buttons you just add $page+1 and $page-1 to the url of the link.
If you need some more help let me know.