Newest news on top

Discussion in 'PHP' started by red-x, Aug 1, 2008.

  1. #1
    I have a news system in my website. But every time I create some news it gets posted in the bottom of the last news. I was wondering what can I do so the newest news go on top of the older ones. Here's my code..

    $getnews = "SELECT * FROM news";
    $News = mysql_query($getnews) or die(mysql_error());
    while($echo_news = mysql_fetch_array($News)) {
    $id = $echo_news["id"];
    $title = $echo_news["title"];
      echo "<div class=\"maintop\">"; echo "<div class=\"date\">" . $echo_news["newsdate"] . "</div><div class=\"maintitle\"><center>"; echo "<a href=\"?pg=article&amp;id=$id \">$title</a>" . "</center></div></div>"; echo "\n<div class=\"mainContent\">\n<p>"; echo $echo_news["news"] . "\n<a href=\"admin/news/delete.php?t=".rawurlencode($title)."&amp;id=$id\" class=\"delete\">Delete</a>\n</p></div>\n"; 
    }
    PHP:
    If you need my Msql table ask me and I'll post it.

    Thanks in advance for any help.
     
    red-x, Aug 1, 2008 IP
  2. MakeThatDollar

    MakeThatDollar Notable Member

    Messages:
    4,451
    Likes Received:
    158
    Best Answers:
    0
    Trophy Points:
    225
    #2
    Try this:

    $getnews = "SELECT * FROM news ORDER BY getnews DESC";
    $News = mysql_query($getnews) or die(mysql_error());
    while($echo_news = mysql_fetch_array($News)) {
    $id = $echo_news["id"];
    $title = $echo_news["title"];
      echo "<div class=\"maintop\">"; echo "<div class=\"date\">" . $echo_news["newsdate"] . "</div><div class=\"maintitle\"><center>"; echo "<a href=\"?pg=article&amp;id=$id \">$title</a>" . "</center></div></div>"; echo "\n<div class=\"mainContent\">\n<p>"; echo $echo_news["news"] . "\n<a href=\"admin/news/delete.php?t=".rawurlencode($title)."&amp;id=$id\" class=\"delete\">Delete</a>\n</p></div>\n"; 
    }
    PHP:
    If that doesn't work, try ASC instead of DESC in the first line.
     
    MakeThatDollar, Aug 1, 2008 IP
  3. red-x

    red-x Peon

    Messages:
    48
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thank you so much!! That worked perfectly. :D
     
    red-x, Aug 1, 2008 IP
  4. MakeThatDollar

    MakeThatDollar Notable Member

    Messages:
    4,451
    Likes Received:
    158
    Best Answers:
    0
    Trophy Points:
    225
    #4
    No problem. Glad to help. :D
     
    MakeThatDollar, Aug 1, 2008 IP