Using PHP to implement the previous, next code _php instance

Copy code code as follows:

<?php
//----Display previous article, next article Code START----

$sql _former = "Select * from article where id< $id the ORDER by id DESC "; Previous article SQL statement. Note that the reverse is reversed because the result set is returned with only the first article, not the last article
$sql _later = "SELECT * from article where id> $id"; Next article SQL statement
$queryset _former = mysql_query ($sql _former);//Execute SQL Statement
if (mysql_num_rows ($queryset _former)) {// Returns the number of records and determines whether it is true, using this as the basis for displaying the results
$result = mysql_fetch_array ($queryset _former);
Echo <a href= ' index.php?id= $result [id] ' > '. $result [title]. "</a><br>";
} else {echo has no <br> on;}

$queryset _later = mysql_query ($sql _later);
if (mysql_num_rows ($queryset _later)) {
$result = mysql_fetch_array ($queryset _later);
Echo Next <a href= ' index.php?id= $result [id] ' > '. $result [' title ']. " </a><br> ";
} else {echo ' next no <br> ';}
?>