return the last ten entries, in decending order 1

[999Dom999]

$row_count = mysql_num_rows(mysql_query("SELECT id FROM en_news"))-10;

$query= "SELECT id,date,title FROM en_news LIMIT $row_count ,10";

Above is the solution of the first part of the question but I want the last entry to display first. I tried:

$query= "SELECT id,date,title FROM en_news ORDER BY id DESC LIMIT $row_count ,10";

But this counts backwards from the 10th to last entry. I could put the data into an array and display it backwards but I'm sure there is a sql statement to help me do this? Its hurting my little brain. Any ideas?

 

[r937]

SELECT * FROM (
SELECT id,date,title FROM en_news
ORDER BY id DESC LIMIT $row_count,10 ) AS x
ORDER BY id

if for some reason this doesn't work, sort the 10 rows in php



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[999Dom999]

Just the ticket!! Thanks so much!! I was getting a bald patch from head scratching!

I used this and works perfectly:

SELECT * FROM (
SELECT id,date,title FROM en_news
LIMIT $row_count,10 ) AS x
ORDER BY id DESC