A question of MySQL...

[Jasconius]

I've just started getting hard into learning PHP these last few weeks.

This week I have been programming my first FUNCTIONAl scripts from scratch, as in they do something that I will actually use.

My question is, I'm trying to think of how I want to create a posting script, for a blog style entry page.

I was wondering if there is a way to create a reverse form of MySQL auto-increment? MySQL auto-increment increases the number of a field for each new entry.. so the first entry is 1.... the next is 2.. and then so forth.

What I would like is an increment that works in reverse. So that the most recently added line is 1, and the older ones get moved back to higher numbers.

That way I can keep a static PHP script to determine which blog entries get printed on the screen... obviously this method would make archiving out of the question (or at least I think it would) but that doesn't matter to me for what I want to do with it.

Anyone know if that is possible? Thanks in advance.

[pohopo]

a better way is in your select statement where you call your entries use 'ORDER BY'

SELECT fields
FROM table
ORDER BY incr_field DESC

ORDER BY defaults as ascending if you want it to descend put DESC at the end

[Drakla]

And you can also use LIMIT to just pull one, or a group out at once, and give it an offset from the order of the result set.
With one parameter the number means how many with two it means offset, howmany
So append to the query above
LIMIT 1 to get just the most recent post

LIMIT 1,1 - gets yesterdays

LIMIT 7,1 - last week's (if one per day)

LIMIT 14,7 - a whole weeks worth from a fortnight ago, etc etc