Hello! 🙂
I do have dates in a database, and try to sort them so the row with the newest date should appear at top, I do list 10 posts/rows.
I save the dates to the mySQL database with this: date("F j, Y, g:i:s a");
Example: April 20, 2003, 7:13:30 am
And the SQL query looks like this:
select * from table1 WHERE approved=1 order by approvedtime desc limit 0,10;
First it seemed to work fine, but now after some hours I had a look at it again and it seems that new posts get only place 9 and 10 now, instead of starting at the top. 😕
