Stepping through auto-increments one at a time?

[Jolten]

Hi all,

Need a little help please.

I've got a table which I insert data into (via a checkbox/submit):

Table:
id ( int(10) auto-increment PRIMARY)
field1
field2
field3 (curdate)
field4 (curdate + inrement)

Values are inserted via admin interaction and can be inserted at any time. Each row of data should only be available to a query once a certain condition is met.

So if I have a query which stated to only pull results if field 2 = (condition) it limits the results.

I'm query this data and displaying 1 record at a time based on the id field. I've got all this worked out.

This is where I need help.....

What I'd like to do is to add some condition to the query or PHP which states to increment the results by id value. Basically, today show the row with the id of 50 then tomorrow show the row with id 51, then the day after show row 52. Does this make any sense? I just want to step through the id fields using data as it's made available. Since the curdate field of the table will contain the date of whenever the information was inserted, I can't use the curdate field to control this.

Any ideas?

None of this is in a loop. It's a script which should always result in 1 result.

Thanks