[RESOLVED] Print the 5 rows with the highest id.

thelinx

I don´t know, but i think the thread title is kinda self-explainatory (spelled wrong?).

I basically want to print out the 5 latest news.

My table structure is:

`id` smallint(6) NOT NULL auto_increment,
`short_name` tinytext NOT NULL,
`name` tinytext NOT NULL,
`short_text` mediumtext NOT NULL,
`text` longtext NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY  (`id`),
UNIQUE KEY `id` (`id`)

I want to sort the rows by the id row, with the highest id first.
I need backup!

// Thanks in advance, Linus MS "TheLinx"

devinemke

SELECT * FROM table ORDER BY date, id DESC LIMIT 5

thelinx

MySQL Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'date, id DESC LIMIT 5' at line 1

thelinx

Im gonna try out with that new thingy, brb.....

thelinx

Nope, still shows oldest first :S

EDIT:
BTW, here is my whole code regarding the mysql_fetchdata thingy...

$topbox_news_fetchdata = mysql_query("SELECT * FROM portal_news ORDER BY date, id DESC LIMIT 5")
or die(msg_failure("Could not fetch data: " . mysql_error()));

while ($row = mysql_fetch_array($topbox_news_fetchdata)) {
newsarticle($row['short_name'], $row['id'], $row['name']);
}

thelinx

Ok, i fixed it!

(Mostly thanks to devinemke 🙂)

I used this SQL sentence:

SELECT * FROM portal_news ORDER BY id DESC LIMIT 5

kthxbai!