How to use PHP+Mysql to query the previous and next articles

This article introduces the knowledge of "how to use PHP+Mysql to query the functions of the previous and next articles". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Get the id of the current browsing article:

$id = isset ($_ GET ['id']) > 0? Intval ($_ GET ['id']): "

The next article:

$query = mysql_query ("SELECT id,title FROM article WHERE id >'$id' ORDER BY id ASC LIMIT 1"); $next = mysql_fetch_array ($query)

Previous article:

That's all for $query = mysql_query ("SELECT id,title FROM article WHERE id" > "how to query the previous and next articles with PHP+Mysql"). Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!