[PHP]Make XX First

[loserWILL]

Ok, say I have some news articles that are displayed using mySQL and PHP.

When I add a new article, the newer one goes at the bottom. How do I make it so the newer one displays at the top.

[Invent]

ORDER BY `lol` DESC 

[loserWILL]

what do I replace with 'lol'?

[Moh]

And if you want it to display only 5 then:

SELECT  * FROM  `news` ORDER  BY `id`  DESC LIMIT 0 , 5 

[loserWILL]

Gosh I'm a nub.

Where would I add that in this:

<?php
include "config.php";

$sql = "SELECT * FROM news";
$check = mysql_query("SELECT authour, title, news_content, date FROM news") or die("There is no news at the moment.");

while ($display = mysql_fetch_array($check)) {

    $news_content = $display['news_content'];
    $title = $display['title'];
    $authour = $display['authour'];
    $date = $display['date'];
    echo "<h2>$title - <span>by $authour</span></h2>
<p>$news_content<br />
<strong><i>Posted on: $date</i></strong></p><br />
<br />
";
    }
?>

NVM: Got it. Thank you Simon and Jack.

[loserWILL]

Egh, the "DESC LIMIT 0 , 5" is causing me problems:

The firts news title is fine, but the second news article's title is shifted to the right When I removed that desc limit it's fine, but it doesn't order the news how I want it to.

[Agnostic Bear]

[quote=loserWILL;4447420]Gosh I'm a nub.

$sql = "SELECT * FROM news";

What the hell do you keep putting that in there for it serves no purpose.

[loserWILL]

I'll remove that.

Does anybody know the answer to the question I posted above?

[Moh]

SELECT * FROM `news` ORDER BY `news`.`id` ASC LIMIT 0 , 5 

The `id` is what its ordering by.

[loserWILL]

That doesn't order it properly, or at leats how I want it to order.