ok i have spent over a week trying to get this stupid thing to work and i just know its probably something simple :mad:
I am trying to link to the next article with a previous / next link, the example below is for the next link
$id=$_GET['id'];
$query = mysql_query("SELECT * FROM article
WHERE id > $id
ORDER BY id DESC
LIMIT 1");
$row = mysql_fetch_array($query);
?><a href="view_article.php?id=<?php echo "$row[id]"?>">next</a>
But all this does is fetches article 65 which is the last article in my database 🙁
anyone know how i can make it link to the next article in my db
eg if im at article 5 and the next article id is 8 i want it to link to article 8
