nginx — 2012-03-24T03:06:27-04:00 — #1
id date panaid
5 1332533806 14
543 1332533943 16
322 1332533825 29
anyone have simple idea to select by date next row?
if true then give next id
guido2004 — 2012-03-24T03:53:36-04:00 — #2
Would you mind explaining a bit more? It's not clear to me what you want.
nginx — 2012-03-24T04:00:36-04:00 — #3
emm get next or previous id by date
previous id(with lower date)
next(with newer date)
guido2004 — 2012-03-24T04:04:15-04:00 — #4
lower than what date?
newer than what date?
Remember that we don't have the slightest idea what you are working on. So a minimum of explanation is required.
nginx — 2012-03-24T05:10:39-04:00 — #5
emmmm find any previous or next results by date if found
if $prevdate then give true
if $nextdate then give true
emm now u understand?:)
guido2004 — 2012-03-24T06:32:27-04:00 — #6
No. You're not explaining anything, to be honest.
nginx — 2012-03-24T10:59:18-04:00 — #7
i have gallery but i don't have code for +1 id and -1 id
Previous- IMAGE +Next
(Previous button give id to go on older image, Next button give id to go on newer image)
r937 — 2012-03-24T12:18:28-04:00 — #8
previous and next make sense only in the context of (1) you're looking at a specific image, and (2) you have a rule which determines sequence
you've already covered (2) in your first post -- by date
now all you have to do is explain (1) -- how you decide which image
nginx — 2012-03-25T10:39:05-04:00 — #9
get id for next or previous row
r937 — 2012-03-25T15:20:34-04:00 — #10
next or previous, or next and previous?
and "next" or "previous" relative to which id?
guido2004 — 2012-03-25T15:45:30-04:00 — #11
That's what I asked before too.
What is your starting point? When you say next and previous, lower and newer, you have to say what your starting point is.
A date given by the user? The current date?
nginx — 2012-03-26T05:18:19-04:00 — #12
yes current date given by user.
r937 — 2012-03-26T06:24:28-04:00 — #13
why do you need the user to tell you the current date?
there's a function for that