Looking for a code: lastest 4 but 1 from a database

[Nothadoth]

Ok im scripting a shop. And i'm confused for a script.
Basically it's a phone shop, and I have a section that shows the latest phone. Thats easy, order by id desc limit 1 right?

But the person i'm doing the shop for also wants (aswell as the latest phone) the next latest 4 phones (so 2nd newest, 3rd newest etc. to 5th newest).

Is there anyway to do this?

So I want to ignore the newest entry in the database but show the next 4 newest.

Thank you

[shocker-z]

I beleave this SQL should work

select * from table limit 4 offset 1

never used offset myself tho so you will need to just try it :0


Regards
Liam