Code: Select all
<?PHP
//pages.php?page=2
$page = ereg_replace('[^0-9]', '', $_GET['page']); //get page number
$page *= 10; //multiple by 10 to get result id's correct
$result = mysql_query("SELECT name FROM search WHERE id>='$page' LIMIT 10");
echo '<hr>';
while($row=mysql_fetch_assoc($result)) {
echo $row['name'];
echo '<hr>';
}?>Code: Select all
SELECT name FROM search WHERE id>='$start' ORDER by id DESC LIMIT 10