Re: problems with proper ordering

[Roland Bouman]

Hi,

you should add a ORDER BY [col] DESC clause to the SELECT expression:

SELECT *
FROM table
ORDER BY dateorder DESC

By the way, you write:

"...included the date-time that isnt displayed on the page so that each post would have a unique non-zero incremented identifier..."

if its important for it to be unique, then don't use datetime, timestamp, etc. Just use AUTO_INCREMENT (see mysql manual for CREATE TABLE)