[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. :P

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. :P

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

[Invent]

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

[Unpredictible.1]

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


thanks

[Moh]

That doesn't order it properly, or at leats how I want it to order.
oops, change ASC to DESC :)

[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

[DeejayMachoo$]

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;

[timROGERS]

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

[loserWILL]

It's fine wihout that sql code.

[redtom]

It's fine wihout that sql code.

No it's not.

[loserWILL]

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

[DeejayMachoo$]

It wasn't like that until I added that code?
You must of mistakenly changed your html.

[loserWILL]

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