How do I sort a list of news posts by latest post?

[shack]

I have a mqSQL database with a row called newsDate
and I'm posting news onto it and then using dreamweaver to pull in the content onto my homepage..

Dreamweaver has the function to sort the content descending by 'newsDate' however if I post more than one post on a day it ain't in order, it just puts all those with the same date at the top of the list?

Can I get it to sort by date and time?

In the admin page for adding news I'm currently using the CURDATE() function to add the date when the users posts news.

Can anyone please help?
Phil

[Weedpacket]

You would have an ORDER BY clause in your select statement to order the results by latest post.
http://www.mysql.com/doc/en/Sorting_rows.html

[shack]

I've got it working using order by then using the unique ID that each column is given.

Is that right?

[robsgaming]

If your ID is set as auto increment, you can sort by it.

SELECT * FROM tablename ORDER BY idrow DESC

This will pull up the latest item added to that table, as long as your id field is auto increment and increases with every post.

[Weedpacket]

Or you could order by the field that stores the date.