View next/previous result in database

[bluns]

Hi all, i am trying to create a next and previous button. It works fine, but when i delete different articles, i get blank pages because it just goes to the next id

It would also be good if the next/previous button stops working if there is no more results after, ie if page = id10 and there are no pages, it will not try go to id11

 <a href="view_article.php?id=<?php $previousarticle=($row-1);
echo $previousarticle;?>">previous</a> 
<a href="view_article.php?car=<?php $nextarticle=($row+1);
echo $nextarticle;?>">next </a>

[Steveo31]

From that it sounds like 'id' is an auto_increment...?

Try using mysql_num_rows and go from there.

[danyprundus]

Well instead of using that id that is auto incremented you'dd better do s sql quesry something like this:
select * from db where condition limit $row,1;
And don't forget to increment $row:

$row++

.

[bluns]

thanks for your help all, although i do not quite understand as im a bit of a nooB :rolleyes:

My query is as follows

$query = mysql_query("select * from article
                      where id = '$row'");

 

This displays all the data for my article. If i wish the user to navigate to the previouse article i have a previous / next button

as you have seen

<a href="view_article.php?id=<?php $previousarticle=($row-1); 
echo $previousarticle;?>">previous</a> 
<a href="view_article.php?car=<?php $nextarticle=($row+1); 
echo $nextarticle;?>">next </a> 

yes id is auto increment, but i dont think that has anything to do with my problem

problem is, if i am viewing article C, i deleted article B so if i press the previous link i want it to go to article A and not B $row-1 seems to be an incorrect command