Jump to content


This topic is now archived and is closed to further replies.


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

Recommended Posts

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

Share this post

Link to post
Share on other sites
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


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.