Listing in Order

[Ahren]

I made a thing for my site, that updates news and then shows it on the news page. The problem is when I post new news, it shows the newer stuff under the old stuff, so the newest stuff is always at the bottom.
I want the new stuff at the top. How can I do this?

I am using a MySQL Database to store the news and dates.

[adrian_quah]

Ahren, try something like this: -

SELECT * FROM your_table_name ORDER BY your_date_field_name DESC

in ur SQL statement..

where your_date_field_name is the name of ur database table's field that stores the dates. You have to ensure what format ur dates are stored as too..if it's the default date format in MySQL, it shd be okay..

[Ahren]

lol...I am a total n00b, what is the default date format?

15/04/03?
DD/MM/YY

or

DD/MM/YYYY

or something else?

[hkucsis]

Instead of using a date field, you can use an "int" field and make it "auto increment". That will do the same trick as a date field.

[Ahren]

OK...I got the date thing all figured out thanks