PHP implementation code for previous and next articles_PHP tutorial

Code:

2. //----Display the previous and next article codes START----
4. $sql_former = "select * from article where id<$id order by id desc "; //Previous article sql statement. Note that it is in reverse order, because only the first article is used when returning the result set, not the last article
5. $sql_later = "select * from article where id>$id "; //Next article sql statement
6. $queryset_former = mysql_query($sql_former); //Execute sql statement
7. if(mysql_num_rows($queryset_former)){ //Return the number of records and determine whether it is true, and display the results based on this
8. $result = mysql_fetch_array($queryset_former);
9. echo "Previous post ". $result [title]."
   ";
10. } else {echo "Previous post No more
    ";} 
11. // www.jbxue.com
12. $queryset_later = mysql_query($sql_later);
13. if(mysql_num_rows($queryset_later)){
14. $result = mysql_fetch_array($queryset_later);
15. echo "Next article ". $result ['title']."
    "; 
16. } else {echo "Next article No more
    ";}
17. ?>

http://www.bkjia.com/PHPjc/729837.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/729837.htmlTechArticleCode: ?php //----Display previous and next article code START--- - $sql_former = "select*fromarticlewhereid$idorderbyiddesc"; //SQL statement of the previous article. Note that it is in reverse order, because...