Would something like this work?
($GET['page']) ? ($page = $GET['page']) : ($page = 1);
$limit = ($page - 1) * 10;
$num = 10; // number of results to display per page
$totalRes = mysql_query("SELECT * FROM yourtable");
$total = mysql_num_rows($totalRes) / $num;
$sql = mysql_query("SELECT * FROM yourtable LIMIT $limit $num");
if($_GET['page'] < $total) {
echo '<a href="index.php?page='.$_GET['page'] + 1.'">next</a>';
}
if($_GET['page'] > 1) {
echo '<a href="index.php?page='.$_GET['page'] - 1.'">Previous</a>';
}