How: Mysql: Next & previous record ?

[marhoons]

Dear all,

good day to you..

it is any way to know the Next  & previous ID after the current record?

 

i draw a simple scenario:

 

please advice and guide me.

 

Thanks,

Yours M a r h o o n

[rarebit]

This subject is known as pagination. Using mysql you use 'limit'

[marhoons]

no my dear i dont meant pagination....

see:

I mean if i display the article has id: 8

the next article should be 4 as my draw figure.

and the previous should be 5.

again i did not mean pagination...

 

thanks for fast reply.

[rarebit]

Its surely the same thing, just that your using id's instead of pages?

Your just using a different search, producing a similar list ordered by id, which is certain terms is identical...

 

If i'm still off track can you re-explain please?

[marhoons]

thanks again....

come with me...

i display article has Id 8 by this syntax:

 

$sql= mysql_query("select * from articles where id='8' ");

$row= mysql_featch_array($sql);

.

.

.

.

.

.

.

 

in this case how i know the next & previous article (recored)?

[LemonInflux]

If I understand you correctly, why not timestamp the articles, then order them by that? If you ID's aren't in logical order, they're probably not the best thing to use.

[marhoons]

my primary indexes & display the article by id ..

i'm asking if there's any specail function to identfy the next & prv. pointer!

thanks again and hope to hear good way...

already this fourms using whats i want to do it!

 

 

[rarebit]

What are you using to order by?

Using limit gets the required element without ever actually caring what the previous or next element are!