[PHP]Make XX First

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.

PHP Code:

---

ORDER BY `lol` DESC 


---

what do I replace with 'lol'?

And if you want it to display only 5 then:

PHP Code:

---

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


---

Gosh I'm a nub. :P

Where would I add that in this:

PHP Code:

---

<?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.

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.

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

$sql = "SELECT * FROM news";

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

I'll remove that.

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

PHP Code:

---

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


---

The `id` is what its ordering by.

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

Code:

---

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

---

Quote:

---

Originally Posted by Invent

PHP Code:

---

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


---

---

thanks

Quote:

---

Originally Posted by loserWILL

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

---

oops, change ASC to DESC :)

Simon & Jack, your code orders it properly (how I want it) but it screws up the title:

http://img158.imageshack.us/img158/7288/huhjr9.gif

Quote:

---

Originally Posted by loserWILL

Simon & Jack, your code orders it properly (how I want it) but it screws up the title:

http://img158.imageshack.us/img158/7288/huhjr9.gif

---

sql doesn't affect the way its displayed on a page;

That's your poor HTML I'm afraid :P

It's fine wihout that sql code.

Quote:

---

Originally Posted by loserWILL

It's fine wihout that sql code.

---

No it's not.

It wasn't like that until I added that code?

Quote:

---

Originally Posted by loserWILL

It wasn't like that until I added that code?

---

You must of mistakenly changed your html.

I don't think so, as I've removed the code and it works fine again.