Posted by Otto on 07/23/05 17:21

Hello Hilarion

> This will work OK only if "nom" values are unique. If they are not, then you'll
> always get other "duplicate" of current record as previous and as next.
> In that case you should use something like:
>
Many thanks four your quick answer.

Yes you are right, they can have duplicate records. In fact I like to now the
next ID and previous ID than I can make a skip and skip -1 button at the bottom
of the windows.

Someting like:
+---------------------+
¦ Nom : xxxxx ¦
¦ Prénom : xxxxx ¦
¦ ... ¦
¦ ¦
¦ ¦
+---------------------+
< > NEW SAVE DEL <-- Buttons

Until yet I did it like that (button to display the next record):
<a href="adresse_edit.php?id=<?= $id+1 ?>">
<img border="0" src="images/co_avant.png" width="32" height="24"></a>

But this solution do not skip to the next record alphabetikally!..

[Back to original message]