[SOLVED] How to get last 20 records from DB

[jjmusicpro]

I am trying to make a news page, where it will show archived news items, and the last 3 news items.

I wanted to do a query to get last 10, display 7 of those with just name/title and date, then the other three, with name/title date and info.

 

I can do it in 2 querys thats fine, i just dont know how to get the last 20 records, then -3 from it.

[raku]

You can try querying to get the total number of rows. Then use LIMIT and OFFSET to choose the last 17.

[hansford]

$count = 0;

while($row = mysql_fetch_array($result)) {

 

if($count < 7){

echo $row['name'] . " " . $row['title'] . " " . $row['date'];

}

else{

echo $row['name'] . " " . $row['title'] . " " . $row['date'] . " " . $row['info'];

$count = 0;

}

count++;

}

 

 

[jjmusicpro]

so in my sql query i can have something like this?

 

select * from newitems ORDER BY ID DESC LIMIT 25 OFFSET -3

[jjmusicpro]

hey that worked thanks!

[eRott]

Do not forget to mark the topic as solved. You will find the button on the bottom left of the page.

 

Take care.