Sorting news

[Kilroy]

Hi, I'm having a problem with sorting. I'm trying to figure out how I can display this news in the opposite order on my site. Can anyone please tell me how? The way it is now each new news post gets displayed underneath the one before but I need them to be displayed above the one before. Can anyone please tell me how?

Thanks, Kilroy

    // Query the database for news
    $result = $db->query('SELECT * FROM news');

    // Display the news
    while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    echo '<div class="content"><div class="newsheader"><img src="forum/style_images/1/nav_m.gif" alt="Arrow" /> ';
    echo $row['NewsTitle'];
    echo '</div><p>';
    echo $row['NewsContent'];
    echo '</p><div class="newsfooter">( ';
    echo $row['NewsDate'];
    echo ' )</div></div>';
    } 

[streetlife]

Kilroy, if you have a date/time field in your table (if you don't then add one!) then you can use SQL to order the results either ascending or descending, like follows:

$result = $db->query('SELECT * FROM news ORDER BY date ASC'); 

[Kilroy]

I have a date field in my table, yes . Thanks for the quick response, trying it out now

[Kilroy]

This is what worked:

    $result = $db->query('SELECT * FROM news ORDER BY NewsDate DESC'); 

Thank you so much

[streetlife]

Good, I think I read you might need to change the 'ASC' for 'DESC' though, my bad.

[streetlife]

Ok, there you go!